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

Question

Good morning!&nbsp;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.&nbsp;Example:&nbsp; left is what we have, right is what I want it to look like after we combine them all.&nbsp;THANK YOU!&nbsp;SHOW 1SHOW 2SHOW 3NAMEADDRESSPHONEEMAIL&nbsp;&nbsp;&nbsp;SHOW 1SHOW 2SHOW 3NAMEADDRESSPHONEEMAIL&nbsp;X&nbsp;&nbsp;JOHN&nbsp;123 STREET555-5555mailto:JOHN@JOHN&nbsp;&nbsp;&nbsp;XXXJOHN&nbsp;123 STREET555-5555mailto:JOHN@JOHN&nbsp;&nbsp;X&nbsp;JOHN&nbsp;123 STREET555-5555mailto:JOHN@JOHN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XJOHN&nbsp;123 STREET555-5555mailto:JOHN@JOHN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

alannavarro · Accepted Answer

Danny_V&nbsp;&nbsp;Hello!&nbsp;I think that creating a pivot table should do the work for what you need. Attached is an excel with the desired output.&nbsp;&nbsp;

Forum Discussion

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

2 Replies

Resources