+ Reply to Thread
Results 1 to 6 of 6

Take Cells from one column and divide up in multiple columns

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    288
    MS-Off Ver
    2016
    Posts
    29

    Take Cells from one column and divide up in multiple columns

    I have one column with 806 rows.

    One cell of data in each row.
    I want to the split out the rows to different columns with 30 in each column.

    Is it possible to do this without having to cut and paste 30 cells at a time?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,705

    Re: Take Cells from one column and divide up in multiple columns

    have you looked at the built in functionality of Text to Columns found on the Data Tab of the Ribbon?

  3. #3
    Registered User
    Join Date
    01-20-2016
    Location
    288
    MS-Off Ver
    2016
    Posts
    29

    Re: Take Cells from one column and divide up in multiple columns

    I'm familiar with Text to Columns.
    I'm not trying to split the contents of the cells into separate columns.

    I'm trying to move the first 30 cells in the column to a separate column.

    Then move the next 30 cells to a different column.

    Example 1.JPG

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Take Cells from one column and divide up in multiple columns

    a
    b
    c
    d
    e
    f
    g
    2
    1
    1
    31
    61
    c2: =index($a$2:$a$997, rows($c$2:c2) + 30 * columns($c$2:c2) - 30)
    3
    2
    2
    32
    62
    4
    3
    3
    33
    63
    5
    4
    4
    34
    64
    6
    5
    5
    35
    65
    7
    6
    6
    36
    66
    8
    7
    7
    37
    67
    9
    8
    8
    38
    68
    10
    9
    9
    39
    69
    11
    10
    10
    40
    70
    12
    11
    11
    41
    71
    13
    12
    12
    42
    72
    14
    13
    13
    43
    73
    15
    14
    14
    44
    74
    16
    15
    15
    45
    75
    17
    16
    16
    46
    76
    18
    17
    17
    47
    77
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    01-20-2016
    Location
    288
    MS-Off Ver
    2016
    Posts
    29

    Re: Take Cells from one column and divide up in multiple columns

    AWESOME!!!! I really appreciate it. That just saved me soooooooo much time. ^5

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Take Cells from one column and divide up in multiple columns

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-13-2015, 03:47 AM
  2. I need to divide one column data into10-15 multiple columns evenly
    By excelisbest in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2014, 06:50 AM
  3. Macro to Divide a Data in Cells and Distribute to X number of Columns
    By paul.serrato in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 12:01 AM
  4. Divide points value between multiple cells
    By CCRich in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2013, 08:50 PM
  5. Replies: 4
    Last Post: 09-26-2012, 12:42 PM
  6. Divide a number into multiple columns
    By monkeyman905 in forum Excel General
    Replies: 1
    Last Post: 10-25-2011, 02:57 PM
  7. Removing Divide from multiple cells?
    By 2000m2 in forum Excel General
    Replies: 3
    Last Post: 04-21-2010, 02:15 PM

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