Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns

Hello,

I have a large data file I need to process. I need to lookup values in column A (which repeat), and find their corresponding unique values in column B, and for each unique item found in B, copy it to C (item 1), D (item 2), E (item 3), etc.

It's a little difficult to explain so I am attaching a basic sample of a before and after file.
I appreciate any help; I'm stumped.

Thank you

Thank you.

I will try and post a better example with some more explanation.

I have a list of products and stores they were purchased at:

Coca Cola | K-Mart
Coca Cola | Walmart
Pepsi | Costco
Pepsi | Costco
(see Initial Data.xls)

I need a function, a lookup I believe, that will find all unique stores and put them in a new column for a given product:

Coca Cola | K-Mart | K-mart | Walmart
Coca Cola | Walmart | K-mart | Walmart
Pepsi | Costco | Costco
Pepsi | Costco | Costco
(see data after column lookup.xls)

I will then apply an advanced data filter for unique records, and delete/hide column B, so that it displays the data like so:

Coca Cola | K-mart | Walmart
Pepsi | Costco
(see data after unique record filter.xls)

I hope this helps, and I appreciate yours