Posts by beealf

    Thank you for the response.

    I am not sure if I am doing it incorrectly but if I copy the formula as is, it's giving me blanks in all cells.

    What could be the reason?

    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.