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
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
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.
Thank you so much! This worked!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks