+ Reply to Thread
Results 1 to 6 of 6

Need to separate large verticle data set into columns with 50 entries

  1. #1
    Registered User
    Join Date
    03-19-2006
    Posts
    2

    Need to separate large verticle data set into columns with 50 entries

    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.

  2. #2
    Jim Cone
    Guest

    Re: 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 .

  3. #3
    Ron de Bruin
    Guest

    Re: Need to separate large verticle data set into columns with 50 entries

    Hi cathalog

    See
    http://www.mvps.org/dmcritchie/excel/snakecol.htm


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "cathalog" <cathalog.24xcuz_1142784901.4171@excelforum-nospam.com> wrote in message
    news:cathalog.24xcuz_1142784901.4171@excelforum-nospam.com...
    >
    > 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
    >




  4. #4
    JE McGimpsey
    Guest

    Re: Need to separate large verticle data set into columns with 50 entries

    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
    <cathalog.24xcuz_1142784901.4171@excelforum-nospam.com>,
    cathalog <cathalog.24xcuz_1142784901.4171@excelforum-nospam.com>
    wrote:

    > 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.


  5. #5
    Roger Govier
    Guest

    Re: 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" <cathalog.24xcuz_1142784901.4171@excelforum-nospam.com> wrote
    in message news:cathalog.24xcuz_1142784901.4171@excelforum-nospam.com...
    >
    > 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
    >




  6. #6
    Registered User
    Join Date
    03-19-2006
    Posts
    2
    Thanks for the prompt reply guys. Very much appreciated...

    Cathal

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1