flaviooooo
New Member
- Joined
- Sep 27, 2017
- Messages
- 3
0
I have a list in Excel that consists of 3 columns:
I would like to transpose this to a horizontal table:
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
I have a list in Excel that consists of 3 columns:
VBA Code:
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:
VBA Code:
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