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

Hi Katie,

You could use the pivot table tool to organize your data. Go to the
following top menu: Data (then go to) PivotTable and PivotChart Report...

You then make sure that your data is being recognized as the data that you
wish Excel to organize for you.
Check off the first radial button, "Microsoft Excel List of Data" within the
first section of the dialogue box and then "PivotTable" in the second
section. Then click through to the end choosing your preferences.

You are then confronted with a blank pivot table whereby you are able to
"drag and drop" pivot table elements from the menue of available fields onto
your pivot table. Try and visualize what you would like to see in your table
and then drag and drop elements accordingly. You can always move row and/or
column fields after-the-fact if you aren't satisfied with your first attempt
to place the page/row/column fields. It usually takes me a few tries to get
it right...

Good luck!
Kent.
--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557


"Katie" wrote:

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