SOLVED

# COMBINE 3 OR MORE ROWS BASED ON CELL VALUE BUT KEEPING UNIQUE VALUES

Copper Contributor

# COMBINE 3 OR MORE ROWS BASED ON CELL VALUE BUT KEEPING UNIQUE VALUES

Good morning!

I am trying to figure out how to take the three lines of the same person and info and combine them into one row but keep the "x" for each of the three shows so we can see who is going to each of the shows but not have three rows for each patron.

Example:  left is what we have, right is what I want it to look like after we combine them all.

THANK YOU!

 SHOW 1 SHOW 2 SHOW 3 NAME ADDRESS PHONE EMAIL SHOW 1 SHOW 2 SHOW 3 NAME ADDRESS PHONE EMAIL X JOHN 123 STREET 555-5555 JOHN@JOHN X X X JOHN 123 STREET 555-5555 JOHN@JOHN X JOHN 123 STREET 555-5555 JOHN@JOHN X JOHN 123 STREET 555-5555 JOHN@JOHN
2 Replies
best response confirmed by Danny_V (Copper Contributor)
Solution

# Re: COMBINE 3 OR MORE ROWS BASED ON CELL VALUE BUT KEEPING UNIQUE VALUES

Hello!

I think that creating a pivot table should do the work for what you need. Attached is an excel with the desired output.

# Re: COMBINE 3 OR MORE ROWS BASED ON CELL VALUE BUT KEEPING UNIQUE VALUES

OF course!

Thank you so much! I appreciate the response and help!
1 best response

Accepted Solutions
best response confirmed by Danny_V (Copper Contributor)
Solution

# Re: COMBINE 3 OR MORE ROWS BASED ON CELL VALUE BUT KEEPING UNIQUE VALUES

Hello!

I think that creating a pivot table should do the work for what you need. Attached is an excel with the desired output.