First : 10048 will never evenly divide into three column. One column will
have one more row of data than the other two.

Second: this can be done manually without programming.
Column A will have rows 1-3350
Column B - Cut rows 3351 to 6699 and paste in Column B Row 1.
Column C - Cut rows 6699 - 10048 and paste in column C row 1.

Now go to Print Preview. Data should be in three columns. If not, adjust
column widths to fit in three columns.
"jfcby" wrote:

Hello,

I have a spreatsheet with one column 10048 rows of data. I would like
to make 3 colums of data. This is how I would like to separate my
data: Page 1 with three colums, Page 2 with three columns, Page 3 with
3 colums, etc. Also, if possible my data needs to be separated after
each page ex: move page 2 column 1 to page 1 column 2, move page 3
column 1 to page 1, then move page 4 column 1 to page 2 column 1,
page 5 column 1 to page 2 column 2, page 6 column 1 to page 2 column
3, etc.

If the above cannot be accomplished. How can I split the data evenly
into three columns?

Thank you for your help,
jfcby