Insert Rows and Transpose

Hi,

I'm trying to create a macro that will insert rows based on the number of items in a row, and then transpose that information into the new rows.

Essentially I'm trying to take my horizontally stores data and make it vertical.

I've attached an example excel sheet to show what I'm trying to do.

Thanks for any help.

Works great! Thanks!

Originally Posted by stanleydgromjr

Niviac,

Welcome to the Excel Forum.


Detach/open workbook ReorgData w1 wR LR LC - Niviac - EF771548 - SDG10.xlsm and run macro ReorgData.


The macro assumes that your raw data is in worksheet Sheet1. It creates a new worksheet Results with the data re-organized per your request.




To test the macro in another workbook:



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, by highlighting the code and pressing the keys CTRL + C
2. Open your 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 by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and 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.

Then run the ReorgData macro.

Thanks, landed here from Google search and found exactly what I was looking for!
Thanks a lot!