Excel 2007 : Sorting Rows of data into one column

**Mike74** · 04-26-2010, 10:31 AM

Hi all-

I have spreadsheet that I need help sorting my data a certain way. Please look at the attached sheet and see if you can help me. I need to do this for a thousand or so people. I can't simply cut paste and transpose...I'd be here forever. Any quick way?

Thanks,

Mike Example.xlsx

**JBeaucaire** · 04-26-2010, 11:37 AM

Using VBA:

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

**Mike74** · 04-26-2010, 12:37 PM

Thanks a lot for helping me...

I don't know if I'm running the macro right or I just gave you a bad example. Can you look at the new sheet I'm posting? For some reason I couldn't get your macro to work. Am I suppose to highlight anything before i run the macro? I'm a newb when it comes to these things. Again, thanks for your time. I really appreciate it.

Mike Example2.xlsx

**JBeaucaire** · 04-26-2010, 01:19 PM

Yes, you're first example was not good reflection. You showed one column of data to repeat at the start and you needed two.

Remove all the blank rows so your data table sits at the top left of the sheet. Blanks just complicate the macro unnecessarily.

I've added a line for FIRSTCOL at the top where you can set the first column to transpose, column 3 in this instance. This will let you use this macro for any set of data no matter how many columns at the beginning should not be transposed.

Please Login or Register  to view this content.

**Mike74** · 04-26-2010, 03:19 PM

Seems to work like a charm....thanks a million. You saved me a ton of time!

**JBeaucaire** · 04-26-2010, 03:38 PM

Be sure to check out my site (link in my signature)...it has lots of code snippets and macros to help, maybe you'll find more of use there.

===
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.