Transpose rows into columns based on same ID value

Hi, I've spent hours trying different formulas I've found on the web and looking through posts and still am not able to figure out a way to do this with VB. I have data in a list of rows. Some of the rows have the same "Customer ID" - i.e. they belong to the same order. I'm trying to transpose the rows that have the same ID into columns in the first row where that ID is found. Not all the customers will have more than one product in their order.
(I apologize for this format. I was trying to get the columns
For example:


STEP 1 (this is where I am stuck)

excel1.jpg


Would get transposed to look like this:

excel2.jpg

Then I would go onto STEP 2: I think if I can get Step 1 above done then I know how to concatenate the rows so that there is just one row for each order. i.e. it will end up looking like this eventually:

excel3.jpg

If someone can help me with "STEP 1" that would be hugely appreciated.

Thx