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

Hi

take a look at David McRitchie's SnakeCol
http://www.mvps.org/dmcritchie/excel/snakecol.htm

--
Regards

Roger Govier


"cathalog" wrote
in message ...

Hopefully someone can help me with this.

I have a large data set (2500 entries) in two verticle columns,

i.e.

x value1, y value1

x value2, y value2

.
.

xvalue2500, y value2500

I need to tabulate this data set for printing, i.e. 14 columns with 50
entries in each on each page. This is incredibly painstaking to do
manually.

Does anyone know if there is a function to do this for me? I want
something to cut the data set into groups of fifty and align them side
by set.

Any ideas?

Help will be greatly appreciated.


--
cathalog
------------------------------------------------------------------------
cathalog's Profile:
http://www.excelforum.com/member.php...o&userid=32609
View this thread:
http://www.excelforum.com/showthread...hreadid=524054