I have imported a huge list of data into excel - the total list extends
waaaay past the limits of Excel. I have broken the list into several
spreadsheets and want to "shorten" the space it consumes by having more then
one column per page.

Isn't there some way to:
read the first 25 lines into columns A-C of Page 1 and then
read lines 26 through 50 and place that data on the same page only in
columns D-F
then read 51 - 75 lines onto Page 2 columns A-C followed by 76 - 100 onto
Page 2 columns D-F

and so on to the end of the list.

By moving the data around this way the total number of pages in the
worksheet could be dramatically reduced by I can't seem to figure out how to
do this -