Macro to transpose data from two columns into multiple rows

**Briansva92** · 08-27-2012, 05:30 PM

I'm trying to copy a larger amount of data that is formatted in two columns. Column A has many repeated values. I need every cell in Column B that have the same value in A to be listed in one row.
I haven't been able to find an existing post that works for my data set, and I am not familiar enough with marcos to edit/trailor code already on the site to solve my problem.

An example of what the data is currently formatted like:

1 A
1 B
2 C
2 D
2 E
3 J
3 K
3 L
3 M

And I need it to look like this:

1 A B
2 C D E
3 J K L M

Does anyone have a Macro that could work for this?

Thanks in advance for the help

**xladept** · 08-27-2012, 06:47 PM

Hi Briansva92,

Jindon wrote one of these the other day - I so admired the code that I saved it, here it is adapted to your example:

Please Login or Register  to view this content.

**Briansva92** · 08-27-2012, 07:13 PM

Thank you so much, it works great. This will save me a lot of time.

**xladept** · 08-27-2012, 07:40 PM

You're welcome! It's Jindon's code though - I wish I'd written it!

**Cutter** · 08-27-2012, 07:55 PM

@ Briansva92

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.