software

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: www.excelforum.com/member.php...oamp;userid=32609
View this thread: www.excelforum.com/showthread...hreadid=524054Hi cathalog

See
www.mvps.org/dmcritchie/excel/snakecol.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;cathalogquot; gt; wrote in message
...
gt;
gt; Hopefully someone can help me with this.
gt;
gt; I have a large data set (2500 entries) in two verticle columns,
gt;
gt; i.e.
gt;
gt; x value1, y value1
gt;
gt; x value2, y value2
gt;
gt; .
gt; .
gt;
gt; xvalue2500, y value2500
gt;
gt; I need to tabulate this data set for printing, i.e. 14 columns with 50
gt; entries in each on each page. This is incredibly painstaking to do
gt; manually.
gt;
gt; Does anyone know if there is a function to do this for me? I want
gt; something to cut the data set into groups of fifty and align them side
gt; by set.
gt;
gt; Any ideas?
gt;
gt; Help will be greatly appreciated.
gt;
gt;
gt; --
gt; cathalog
gt; ------------------------------------------------------------------------
gt; cathalog's Profile: www.excelforum.com/member.php...oamp;userid=32609
gt; View this thread: www.excelforum.com/showthread...hreadid=524054
gt;
One way:

C1: =INDEX($A:$B,INT((COLUMN()-1)/2)*50 ROW(),2-MOD(COLUMN(),2))

Copy C1 to C1:CV50
Copy over to In article
gt;,
cathalog gt;
wrote:

gt; Hopefully someone can help me with this.
gt;
gt; I have a large data set (2500 entries) in two verticle columns,
gt;
gt; i.e.
gt;
gt; x value1, y value1
gt;
gt; x value2, y value2
gt;
gt; . .
gt; . .
gt;
gt; xvalue2500, y value2500
gt;
gt; I need to tabulate this data set for printing, i.e. 14 columns with 50
gt; entries in each on each page. This is incredibly painstaking to do
gt; manually.
gt;
gt; Does anyone know if there is a function to do this for me? I want
gt; something to cut the data set into groups of fifty and align them side
gt; by set.
gt;
gt; Any ideas?
gt;
gt; Help will be greatly appreciated.

Hi

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

--
Regards

Roger Govierquot;cathalogquot; gt; wrote
in message ...
gt;
gt; Hopefully someone can help me with this.
gt;
gt; I have a large data set (2500 entries) in two verticle columns,
gt;
gt; i.e.
gt;
gt; x value1, y value1
gt;
gt; x value2, y value2
gt;
gt; .
gt; .
gt;
gt; xvalue2500, y value2500
gt;
gt; I need to tabulate this data set for printing, i.e. 14 columns with 50
gt; entries in each on each page. This is incredibly painstaking to do
gt; manually.
gt;
gt; Does anyone know if there is a function to do this for me? I want
gt; something to cut the data set into groups of fifty and align them side
gt; by set.
gt;
gt; Any ideas?
gt;
gt; Help will be greatly appreciated.
gt;
gt;
gt; --
gt; cathalog
gt; ------------------------------------------------------------------------
gt; cathalog's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32609
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=524054
gt;
You can paste into Word and use Format | Columns
-or -
David McRitchie has some vba code to experiment with in Excel...
www.mvps.org/dmcritchie/excel/snakecol.htm
-or -
buy a commercial application.

Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;cathalogquot; 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 .


Thanks for the prompt reply guys. Very much appreciated...

Cathal--
cathalog
------------------------------------------------------------------------
cathalog's Profile: www.excelforum.com/member.php...oamp;userid=32609
View this thread: www.excelforum.com/showthread...hreadid=524054