Can someone help me convert the layout of an Excel spreadsheet? I think the example in the attached picture says it all. If I knew what the technical term for what I am trying to do, I would google it, but I don't. In a way it's like transposing, but I don't want to repeat the type column.
Plus the list I am looking at is 1000 rows long.
Thanks,
Neil