dear friends,
I have a spreadsheet where i would like to transpose data from 3 groups of five cells (row) into 3 columns. I am able to create a macro but cannot create the loop to run for all rows in the xls. can u pl help?
In attached xls i would like a macro to loop as follows:
1. insert 4 rows after every row starting with row 2 (headers row1)
2. from row 2: copy cells A2-J2, paste into rows 2-4 (A3-J6)
3. transpose/copy-paste cells K2:O2 TO K2:K6
4. transpose/copy-paste cells X2:AB2 TO X2:X6
5. transpose/copy-paste cells AC2:AG2 TO AC2:AC6
6. LOOP: start with A7 (previously A3) and repeat above, continue till last row with data in col A.
Pl provide instructions on how to use in other spreadsheets with larger no of rows but same columns.
thanks for your help.
Bookmarks