View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default Need to separate large verticle data set into columns with 50 entries

You can paste into Word and use Format | Columns
-or -
David McRitchie has some vba code to experiment with in Excel...
http://www.mvps.org/dmcritchie/excel/snakecol.htm
-or -
buy a commercial application.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"cathalog" wrote in message...
Hopefully someone can help me with this.
I have a large data set (2500 entries) in two vertical columns,
i.e.

x value1, y value1

x value2, y value2 .