+ Reply to Thread
Results 1 to 6 of 6

Moving Multiple Rows from One Column to Multiple Columns

  1. #1
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    332

    Moving Multiple Rows from One Column to Multiple Columns

    I'm trying to figure out a quick way to move data that is in one column over into multiple columns. I think this can be done easily but I'm not sure the best way to go about it. I've provided an example that explains the current data layout and what I would expect the results to look like.

    Thanks for looking!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Moving Multiple Rows from One Column to Multiple Columns

    How about
    In D1 copied across
    =INDEX($A$1:$A$30,AGGREGATE(15,6,(ROW($A$1:$A$30)-ROW($A$1)+1)/(LEFT($A$1:$A$30,5)="Route"),COLUMNS($D$1:D$1)))

    In D2 copied down 12 rows and across
    =INDEX($A$1:$A$30,MATCH(D$1,$A$1:$A$30,0)+ROWS($D$1:$D1))

  3. #3
    Forum Contributor
    Join Date
    01-25-2013
    Location
    near Philly, PA USA
    MS-Off Ver
    Excel 2019
    Posts
    178

    Re: Moving Multiple Rows from One Column to Multiple Columns

    Try attached.
    If original data need to be deleted that can be done.
    Attached Files Attached Files

  4. #4
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    332

    Re: Moving Multiple Rows from One Column to Multiple Columns

    Quote Originally Posted by Fluff13 View Post
    How about
    In D1 copied across
    =INDEX($A$1:$A$30,AGGREGATE(15,6,(ROW($A$1:$A$30)-ROW($A$1)+1)/(LEFT($A$1:$A$30,5)="Route"),COLUMNS($D$1:D$1)))

    In D2 copied down 12 rows and across
    =INDEX($A$1:$A$30,MATCH(D$1,$A$1:$A$30,0)+ROWS($D$1:$D1))
    Thanks, Fluff! Worked perfectly!

  5. #5
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    332

    Re: Moving Multiple Rows from One Column to Multiple Columns

    Quote Originally Posted by bob33 View Post
    Try attached.
    If original data need to be deleted that can be done.
    Thanks, Bob! Whatever you did worked but I was needing the formulas to utilize in my actual database. I appreciate the input!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Moving Multiple Rows from One Column to Multiple Columns

    Glad to help & thanks for the feedback.

+ 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. Help - Moving data from across multiple columns into rows
    By cadler1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-31-2017, 11:22 PM
  2. [SOLVED] Moving multiple columns (8 x sets of 3) with data in separate rows into 3 columns
    By Emmax in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-03-2016, 01:23 PM
  3. Replies: 5
    Last Post: 01-04-2016, 01:42 PM
  4. [SOLVED] Moving cells from one column into multiple columns
    By RetroJK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2013, 09:53 PM
  5. Replies: 2
    Last Post: 07-09-2012, 01:44 PM
  6. Issue moving data with multiple rows into columns
    By fguardia in forum Excel General
    Replies: 2
    Last Post: 07-30-2010, 11:53 AM
  7. Moving multiple customers in columns to rows
    By jordan.lawrance in forum Excel General
    Replies: 1
    Last Post: 05-18-2009, 04:16 AM

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