Good Afternoon -

I have a worksheet that has multiple entries on the first line for different
customer numbers, some have multiple entries, some only have 1. I am trying
to bring up the "column B" for each of the entries into C1 and D1 etc so that
they form a horizontal row, instead of having multiple entries.

For example, I now have;

Customer
123 Blue
456 Blue
456 Green
789 Purple
789 Blue
789 Green

And I would like to have

123 Blue
456 Blue Green
789 Purple Blue Green

Is there any function that anyone knows of to perform this? Or even a
thought process for a macro?

Thank you in advance for your help!

Katie