Please Help! Macro to move cells from columns to rows?

**swdawg25** · 05-25-2012, 12:41 AM

So I have a list of thousands of names and occupations; however, they are not in the format that I would like. I was hoping someone could help me out with a VBA macro. My list currently looks like this:

Column A Column B Column C Column D Column E
Name 1 Name 2 Name 3
-----------------------------------------------------BLANK ROW------------------------------------------
Occupation 1 Occupation 2 Occupation 3

I'd ulitmately like the information to look like the following

Column A Column B
Name 1 Occupation 1
Name 2 Occupation 2
Name 3 Occupation 3

I hope someone can please help me with this, I can do it by cut and paste. But, that would take me hours and hours of just clicking the mouse. I've included an attachment excel example in case someone doesn't understand what I'm trying to do. Oh, and I use Excel 2007 in case you need that information. Any help will be tremendously appreciated.

Excel Forum Help Question.xlsx

Sean

**JapanDave** · 05-25-2012, 01:01 AM

Try this and see if it is what you want.

**swdawg25** · 05-25-2012, 11:27 AM

Dave,

Thanks for the help. It isn't exactly what I'm looking for because I didn't explain my situation perfectly. After the first three names and occupations, the columns reset so that Name 4 is now under Name 1 column. See attached spreadsheet so you can see what I mean. Thanks for your help in advance.

Excel Forum Help Question.xlsx

Sean

**JapanDave** · 05-25-2012, 06:26 PM

Ok, I am looking at your next workbook and can't help seeing another problem coming up after I do the next macro due to there being only two sets of data equaling 6 names in totall. Unless of coarse the maximun amount of names is 6. So I am going to go ahead and do it on the assumption that will be more than 6 names at any given time.

Try this