Friday, 24 January 2020

pivot table - Excel - Finding all values in one column for unique values in another column

I have an Excel table that looks like this:


Code | Description
-------------------------
A | Desc1
A | Desc2
B | Desc3
C | Desc4
C | Desc5
C | Desc6
...

I need to find all the Descriptions for each unique Code. For example I want a table that looks like this:


Code | Description1 | Description2 | Description3
-----------------------------------------------------
A | Desc1 | Desc2 |
B | Desc3 | |
C | Desc4 | Desc5 | Desc6

Is there a way to do this in Excel? I tried Pivot Tables, but had no luck.

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...