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

[Danny_V]

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 · Accepted solution]

@Danny_V 

Hello!

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

[#3]

OF course!

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