I have a list in Excel that consists of 3 columns:
Reference - Feature ID - Feature Value A - Size - 42 A - Colour - Green A - Height - High B - Size - 43 B - Colour - Red C - Colour - Red C - Height - High
I would like to transpose this to a horizontal table:
Reference - Size - Colour - Height A - 42 - Green - High B - 43 - Red - (blank) C - (blank) - Red - High
Is there an easy way to do this in Excel VBA? The values will consist of text and numbers, so I can’t use a simple pivot (I think) The format won’t always be the same either, this simple example uses Size, Colour and Height but it should work dynamically.
I’ve been looking for a solution to this for a while now, but without success. I always end up with solutions for the other way around (from the table to a list) 🙂 Any help will be highly appreciated 🙂