Formula help

Can someone point me to the right direction please?

Attached is my data. I need to show a product and the all the region 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. This is only an example.


Thanks,