Hi all,

I'm looking for a formula or a way in which i can show a product (i.e A) then lookup all the region and display them in the same row. Is there a way to do that? I even consider to concatenate all regions in a single cell.

My workbook has a few thousand line therefore manual input is not ideal.

Attached is the sample.

Thanks,
Haha

Attached Files

Test.xlsx (10.1 KB, 11 views)