Setup of what my spreadsheet currently looks like: several rows of people's names in various formats ( repeated) along with different info in each row/column for the same person. Generically, it looks like this:
Last Name First Name X Y Z
Smith Toby yes
Smith Toby R. no
Smith, Toby yes
What I need to get at: finding a way to condense all the info so each person only has 1 row with the various information pertinent to them. Ideally look like this:
Last Name First Name X Y Z
Smith Toby yes no yes
What kind of formula can help me do this without going through each row line by line?
Last Name First Name X Y Z
Smith Toby yes
Smith Toby R. no
Smith, Toby yes
What I need to get at: finding a way to condense all the info so each person only has 1 row with the various information pertinent to them. Ideally look like this:
Last Name First Name X Y Z
Smith Toby yes no yes
What kind of formula can help me do this without going through each row line by line?