Using a macro to convert groups of rows to columns

**LittleLisa** · 10-26-2012, 04:46 AM

Hi,

I'm a first timer here

I have a list of data currently sorted into rows. I have group names and then a number of entries in the group - the number of entries in a group varies from 1 - 10. I need to 'transpose' the data in rows into columns in another worksheet. It's a bit tricky to explain, so I have attached a copy of the spreadsheet for an example. I could do this manually, but it would be a laborious task being that I have a max of 200 names and 75 or so groups.

Does anyone have any ideas how to go about doing this? In my head I know what I would like the macro to do, but I can't put it into effect.

Thanks in advance if anyone can help. It would be much appreciated.

**RHCPgergo** · 10-26-2012, 05:10 AM

Hi,

can you explain why you want to do this? The original way of arranging data seems more effective... What do you want to do with this data? If you want to see how many "names" are in each "group", you can easily do that with a pivot table.

edit: Here's what I'm saying in a sample file.

**LittleLisa** · 10-26-2012, 05:31 AM

Hi RHCPgergo,

I've tried the pivot table option too. Tried a few different combinations using the data, but not quite what I was looking for.

I need this to be able to setup a mail merge, so need the titles across the page.

Thanks for your reply though.

LittleLisa

**RHCPgergo** · 10-26-2012, 12:29 PM

Hi again,

I hope this is what you wanted, had quite a lot of work with it. I learned a lot though, so thanks for the opportunity.

Please Login or Register  to view this content.

**LittleLisa** · 10-26-2012, 02:56 PM

Hi RHCPgergo,

OMG! You are amazing!!

Problem solved.

Thanks so much for that, you don't know how much trouble you have saved me.

LittleLisa

**RHCPgergo** · 10-26-2012, 05:15 PM

Yay!

I' m glad it works for you.

**Cutter** · 10-27-2012, 01:50 PM

@ LittleLisa

Welcome to the forum.

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.