If you only have to do this once, I'd do this:

Save the original file and do this on another copy (just in case)
1) Add a helper column.
2) Enter the values 1,2,3 ... all the way down through the data.
3) Copy all rows and paste at the bottom.
4) For the last group of rows, delete the data that you don't want in the
"second" row
5) For the first group of rows, delete the data that you don't want in the
"first" row
6) Sort on the helper column


"Ray Elias" wrote in message
...
Let's say I have a workbook with 6 columns of data and 2 rows of data.
(simplified for easier explanation)

I want to, in a new spreadsheet, re-organize it so it's better formatted
for
printing.

Here's what I want to do. For each existing row, I want to turn it into 2
rows on the new workbook.

For example, In the new workbook, I want row 1 columns A-C in row 1
Columns
A-C, and I want row 1 columns D-F in row 2 columns A-E. Then from the old
workbook, I want the old row 2 to take up rows 3 & 4 in the new workbook.

OLD:
R1CA R1CB R1CC R1CD R1CE R1CF...
R2CA R2CB R2CC R2CD R2CE R2CF...

NEW:
R1CA R1CB R1CC
R1CD R1CE R1CF
R2CA R2CB R2CC
R2CD R2CE R2CF


I cannot, for the LIFE of me, figure out how to do this
(easily/automatically) for a LARGE amount of data (200 Rows, 20
Columns ---
400 Rows, 10 Columns).

Any help would be GREATLY appreciated (before I pull out the remainder of
my
hair)