You can also paste the data into Word and use its Columns feature.
Then paste the arranged data back into Excel
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"jp1733"
wrote in message
Hi,
I Have A Large List Of Customers And I Exported A Report Into Excel
That Has Their First And Last Name In One Column And Their Street
Address Only In The Second Column.

With 6000 Customers On My List, I Have Something Like 125-130 Pages Of
Customers In Size 7 Or 8 Font. With Only Two Rows Of Information On
Each Page, I'm Wasting A Lot Of Space To The Right Of All The Info On
Each Page.

I'm Trying To Make It So The Names Stay In Order And In Return Having
Multiple Columns Of Names On Each Page Instead Of Listing Them Straight
Down And Having 130 Pages

My Question Is:
How Can I Sort The Data So I Can Use The Whole Page And Carry The Very
Last Name On The Bottom Left Of The First Page To The Top-right Of The
First Page. For Example, John Doe -123 Bee St Is The Very Last Name And
Address On The First Page. How Can I Get The Next Name For Example,
(john Dunn) Which Is Supposed To Be On The Next Page To Move To The
Top-right Of The First Page.

I'm Sure There Is A Better Way Of Saying All Of That But I Hope You
Understand And Can Help

John


--
jp1733
------------------------------------------------------------------------
jp1733's Profile: http://www.excelforum.com/member.php...o&userid=37566
View this thread: http://www.excelforum.com/showthread...hreadid=571964