Column to Rows

[Brianfree]

Hello, i have an excel document in the following format..

ColA, ColB
Apple, 123
Apple, 345
Pear, 678
Grape, 890
Orange, 111
Orange, 222
Orange, 333
Etc..

I need to convert to

ColA, ColB, ColC
Apple, 123, 345
Pear, 678
Grape, 890
Orange, 111, 222, 333

Please can anyone help?

Many thanks,

Brian

 

[SkipVought]

Don't you really mean...

I need to convert to

ColA, ColB, ColC, ColD

???

What are your table heading values? I think they are
Name, Value.

But there also seems to be an implied value of Occurrence. Anyhow, a PivotTable would do nicely assuming all the assumptions I made, and could be accomplished in about 15 seconds.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[SkipVought]

Here's my version of your data...

The source data table on left, converted to a Structured Table via Insert > Tables > Table, named Table1, showing the formula for sequence of each Name...

The Pivot result using a formula to display the NmVal for each NmSeq for any Name...

You can use Data > Distinct List to gen the unique list of Names.

Hope this helps.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein