×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Column to Rows

Column to Rows

Column to Rows

(OP)
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

RE: Column to Rows

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Column to Rows

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close