EXCEL FORMULA

  • 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.


  • 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?

  • Hello,


    Instead of the usual standard Enter key ... just use simultaneously the 3 keys : Control Shift Enter


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Already indicated what you are doing wrong ...


    See attached test file ...


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Thanks for your Thanks ... which are addressed to bosco_yip ... who provided you with the answer ... a while ago ...!!! :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)