Formula help

[Haha88]

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,

[oeldere]

If you change the title of the treat, according to the forumrules, I will give you my solution.

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

[Haha88]

Please advise what the title should be and I will change it.
My heading is quite appropriate (in my opinion) because I am looking for a formula to get to my solution.

Thanks,

[oeldere]

Mabye like this?

Rearange data from vertical into horizontal.

[Haha88]

Thank you.

[AlKey]

Please see attached file with formulas.