+ Reply to Thread
Results 1 to 2 of 2

Split Data into User Defined Groups

  1. #1
    Registered User
    Join Date
    01-07-2011
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    12

    Split Data into User Defined Groups

    I have a list of numbers in column A that i would like to be seperated into every other column in groups of X amount. Sometimes it can be 15 and sometimes it can be 18. I would like the user to be able to select the amount the groups, the amount of the columns and the amount of the rows the data will be broken out into.

    The data needs to be pasted into a program that only accepts it in a particular way.

    I want the data to go from this:

    Column A
    1
    2
    3
    4
    5
    6
    7
    8
    9

    To this (if the user selects groups of 3, 3 columns, 3 rows.)
    Column B Column C Column D
    1 4 7
    2 5 8
    3 6 9

    Any help would be appreciated.
    Thanks

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Split Data into User Defined Groups

    In B1 and copy across and down,

    =INDEX($A:$A, 3*(COLUMNS($B1:B1) - 1) + ROW())
    Entia non sunt multiplicanda sine necessitate

+ 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