Transpose columns into multiple rows

**taylorj3** · 08-13-2013, 06:17 AM

Hi Everyone,

I'm having some difficulty getting a macro to transpose the data I have into multiple columns. Basically I want to keep the ID field as the first column and then take each column's data (including the header as a new column) and transpose into rows.

I've created an ouput sheet in the attached example to show you exactly what I mean.

PS - there could be more columns in the final version so I would need it to loop until all columns are transposed

Can anyone help with the macro to get me from the input to the output ?

Many thanks in advance.

Transpose columns to rows - help.xlsm

**stanleydgromjr** · 08-13-2013, 08:41 AM

taylorj3,

Welcome to the Excel Forum.

Thanks for the workbook.

With your raw data in worksheet Sheet1, the results will be in worksheet Sheet2.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgData macro.

**taylorj3** · 08-14-2013, 08:28 AM

That's a beautiful Macro that works perfectly - thank you very much for your help and for welcoming me

**stanleydgromjr** · 08-14-2013, 07:41 PM

taylorj3,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

Transpose columns into multiple rows

LinkBack

Thread Tools

Rate This Thread

Display

Transpose columns into multiple rows

Re: Transpose columns into multiple rows

Re: Transpose columns into multiple rows

Re: Transpose columns into multiple rows

Thread Information

Users Browsing this Thread

Similar Threads

Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple columns

[SOLVED] How to transpose one column into multiple rows and columns?

[SOLVED] How to transpose non-uniform data in multiple columns into multiple rows?

transpose multiple rows into two columns

transpose multiple rows and columns

Bookmarks

Bookmarks

Posting Permissions