I have an issue and I don't know if there's a way out. I have a large spreadsheet (8000 Rows) that I need to manipulate, where data was put into additional columns when it should've been put into a 2nd and 3rd row instead. Each entry spans one large row instead of 3 small rows as it should be. So now I need to create two new rows after each existing row. Then take data in columns C-F, and move it to the next row (columns A-D). Then take columns G-H and move that to the 3rd row in the series (Columns A-B).
So an example would be:
Original Data:
A1 A2 A3 A4 A5 A6 A7 A8
B1 B2 B3 B4 B5 B6 B7 B8
Resulting Data:
A1 A2
A3 A4 A5 A6
A7 A8
B1 B2
B3 B4 B5 B6
B7 B8
And so on, until 8000 rows becomes 24000 (or 32000) rows. Is there any help for me out there?
Thanks!
Bookmarks