+ Reply to Thread
Results 1 to 4 of 4

How to combine multiple rows in to one row

  1. #1
    Registered User
    Join Date
    04-24-2018
    Location
    Arlington
    MS-Off Ver
    365
    Posts
    2

    Exclamation How to combine multiple rows in to one row

    I want to combine multiple rows into one row within a group:

    I want to go from this:

    Name
    DOB
    Case Number

    Name
    DOB
    Case Number

    To this:

    Name, DOB, Case Number
    Name, DOB, Case Number

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: How to combine multiple rows in to one row

    Hello and welcome to the forum.

    Try something like this:

    =INDEX(A:A,(ROWS($1:1)-1)*4+1)&", "&INDEX(A:A,(ROWS($1:1)-1)*4+2)&", "&INDEX(A:A,(ROWS($1:1)-1)*4+3)

    Drag the formula down as far as needed.

    This assumes that your data starts in row 1. You can modify it to suit your needs.

  3. #3
    Registered User
    Join Date
    04-24-2018
    Location
    Arlington
    MS-Off Ver
    365
    Posts
    2

    Smile Re: How to combine multiple rows in to one row

    Thank you so much! This worked!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: How to combine multiple rows in to one row

    You're welcome, happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Combine multiple rows into 1 row
    By talkingsoda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2017, 09:29 PM
  2. Combine multiple rows into one row
    By shani20 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2015, 06:30 PM
  3. Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  4. [SOLVED] Combine Multiple Rows
    By mphillips in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2013, 11:58 AM
  5. [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
  6. Combine multiple rows into one row
    By tyankee in forum Excel - New Users/Basics
    Replies: 20
    Last Post: 06-21-2012, 08:02 PM
  7. Combine multiple rows into one row
    By KelMel in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-08-2011, 05: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