I have a set of data with over 100 000 rows with an extract of the below information.
The data consists of codes such as GD1, GD4, GD5, etc. under different categories such as Ship, Overal, Ctnr, etc.
I would like a formula that can swap that and give me the categories under each of the codes as indicated in the yellow highlighted result section in the below image.
I can do it if the codes I don't have the same code under different categories. How do you extract all the categories relating to the same code in excel. The expected result should be similar to the yellow highlighted below.