0

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 🙂

Anonymous Asked question May 14, 2021