+ Reply to Thread
Results 1 to 2 of 2

Combine multiple rows into 1 row

  1. 07-11-2017, 05:36 PM #1
    talkingsoda
    talkingsoda is offline
    Registered User
    Join Date
    07-11-2017
    Location
    nyc
    MS-Off Ver
    2013
    Posts
    1

    Combine multiple rows into 1 row

    Hi

    I'm trying to consolidate data and I need to convert the formats like so:

    start:
    1 2 3 4 5
    6 7 8 9 10
    11 12 13 14 15

    end result:
    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

    I can't seem to get it right. Thank you!
    Reply With QuoteRegister To Reply
  2. 07-11-2017, 09:29 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Combine multiple rows into 1 row

    Hi talkingsoda. Welcome to the forum.

    With the data as in A2:E4 enter this formula in A7 fill across until you get blanks.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Does this do what you want?


    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    1
    start:*
    2
    1
    2
    3
    4
    5
    3
    6
    7
    8
    9
    10
    4
    11
    12
    13
    14
    15
    5
    6
    end result:
    7
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine multiple rows into one row
    By shani20 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2015, 06:30 PM
  2. How to combine multiple rows of data into a single row (with multiple columns)?
    By probeen in forum Excel General
    Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  3. Combine multiple rows that contain the same value
    By dmcearchern in forum Excel General
    Replies: 3
    Last Post: 03-20-2013, 08:30 PM
  4. [SOLVED] Combine multiple rows into one row
    By gan143 in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 09-10-2012, 01:34 AM
  5. Combine multiple rows to one row
    By sojo0801 in forum Excel General
    Replies: 5
    Last Post: 01-19-2012, 01:10 PM
  6. Combine multiple rows into one row
    By KelMel in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-08-2011, 05:15 PM
  7. Combine multiple rows to 1 row.... help
    By Jeroen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2006, 11:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1