Forum Discussion

Danny_V's avatar
Danny_V
Copper Contributor
Jan 13, 2022
Solved

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 goi...
  • alannavarro's avatar
    Jan 14, 2022

    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.

     

     

Resources