transposing column 2 for duplicates in column 1

[mikemeadeuk]

Hi guys,

So i have a list of products in column 1, and a list of similar products in column 2.

For example like this:

PRODUCT A | PRODUCT C
PRODUCT A | PRODUCT D
PRODUCT B | PRODUCT E
PRODUCT B | PRODUCT F

I want to be able to do a formula that ends up like this:

PRODUCT A | PRODUCT C | PRODUCT D
PRODUCT B | PRODUCT E | PRODUCT F


I can manually select the cells in column B and transpose, and then remove duplicates in column A, but when theres thousands of products and tens of similar products its going to take forever!

Please can someone help?

thanks

[Pete_UK]

Attach an example file then we can play about with a few formulae for you.

Pete

[mikemeadeuk]

Hi Pete, thanks for the reply.

I have attached an example file.

[Pete_UK]

Hi Mike,

can you extract a unique list of products from column A yourself, or do you want a way of doing that as well?

Pete