+ Reply to Thread
Results 1 to 5 of 5

Re-arrange multiple rows into a single row

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    Calgary, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re-arrange multiple rows into a single row

    Hello,

    I am trying to move multiple rows and copy them in just a single row; something like the following:

    Input arrangement:

    row1 20 30 40 50

    row2 60 70 80 90

    row3 100

    and I would like to move row2 and row3 to the row1, like:

    Output arrangement:

    row1 20 30 40 50 60 70 80 90 100

    My spreadsheet has more than 60K rows, so I am looking for a suitable way of doing it faster. Could you help me with it?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Re-arrange multiple rows into a single row

    You want 60,000 rows into ONE row?
    Why?

    Assuming you ONLY have three columns and 60,000 rows, you are going to need 180,000 columns, where Excel 2007+ only has 16,384 columns.

    What are you trying to accomplish, as there is likely and easier way?
    Last edited by mikeTRON; 04-24-2015 at 02:07 PM.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    04-24-2015
    Location
    Calgary, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re: Re-arrange multiple rows into a single row

    mikeTRON,

    Sorry about it. I totally forgot to be more specific here.

    I have a file with 60K+ rows which I need to arrange every 3 rows into a row, i.e.,

    row1 1 2 3
    row2 4 5 6
    row3 7 8 9
    row4 a b c
    row5 d e f
    row6 g h i
    .....

    After re-arranging them:

    row1 2 3 4 5 6 7 8 9

    row4 a b c d e f g h i
    .....

    It looks like easy but I do not know how to deal with it.

    Thanks in advance...

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Re-arrange multiple rows into a single row

    What is the purpose?

  5. #5
    Registered User
    Join Date
    03-12-2015
    Location
    UK
    MS-Off Ver
    2013 & 2010
    Posts
    27

    Re: Re-arrange multiple rows into a single row

    If there are just 3 columns of data in your worksheet, as in your example above, insert the formula below into cell D1 and drag down. Then if you want you can used fixed width or space based delimination under 'text to columns' to separate characters from the resultant string into individual cells. This would require pasting (special) formula values over the formulas to prevent the formulas, rather than the formula results being delimited.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    It would result in

    1 2 3 123456789
    4 5 6 456
    7 8 9 789
    a b c abcdefghi
    d e f def
    g h i ghi

+ 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. [SOLVED] Need to extract text from within multiple strings and arrange it in a single column
    By sampflederer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2013, 01:35 PM
  2. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  3. [SOLVED] Single product with multiple variations in multiple rows need to consolidate to single row
    By 65monroe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2013, 01:42 AM
  4. Replies: 2
    Last Post: 02-23-2013, 06:54 AM
  5. [SOLVED] Multiple rows of horizontal data needing to arrange vertically (stacked)
    By jpeets645 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2012, 12:07 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