0
I need to show each description as combined separate column which point to a unique code. Each code has multiple descriptions and they may be blank and I need to show the blanks
I need some kind of macro or pivot table because i recieve multiple files with the wrong format.
Thanks I have an Excel table that looks like this:
Code | Description1 | Description2 | Description3
-----------------------------------------------------
A | Desc1 | Desc2 |
B | Desc3 | |
C | Desc4 | Desc5 | Desc6
I need to find all the Descriptions
for each unique Code
. For example I want a table that looks like this:
Code | Description
-------------------------
A | Desc1
A | Desc2
A |
B | Desc3
B |
B |
C | Desc4
C | Desc5
C | Desc6
...
Is there a way to do this in Excel? I tried Pivot Tables, but had no luck.
Also refer to this link: https://stackoverflow.com/questions/20541905/convert-matrix-to-3-column-table-reverse-pivot-unpivot-flatten-normal
– Bharat Anand – 2018-03-26T23:08:48.650