Formatting imported data

[Jonesl1]

I am having a simple issue in which I just can't figure out. I'm sure it's possible, but for the life of me can't seem to figure it out.

Here it is:
I have imported a list of data into an excel spreadsheet. This list is just a bunch of users names. When the data was imported, it placed the first entry in A1, the next in A2, etc. All the way up til A2000. Nothing was ever put into B$. Each field is just a username. The problem is when it comes to printing the document. I don't want to print a ton of pages with just a little data on each page. I would like to be able to print say A1 through A30 and then wrap A30 through A60 up into column's B1 through B30 and so on. Then once I have wrapped say 5 or 6 columns, to go onto the next page and begin the same sequence (hopefully this makes sense).


So for instance:

A
B
C
D
E
F

and I would like it to look like

A D
B E
C F

I know I could cut and paste each set, but there are 2000 and that would take a load of time to do. Is there some option that would do this for me?

Anyhow, this is causing a printing nightmare and I just need some help.

Thanks in advance!

 

[acw]

Hi


Put

=OFFSET($A$1,(COLUMN()-1)*30+ROW()-1,0)

in B1 and copy down to B30, then across as required.

Tony

 

[acw]

Also see

http://www.mrexcel.com/board2/viewtopic.php?t=179532


Tony