Condensing Entries based on name and other value

[ltensmeyer]

Hopefully this makes sense. So I have to read in an excel sheet that will have information similar to this:

NAME                 ENROLLED

Ethan Kirk	TRUE
Ethan Kirk	FALSE
Ethan Kirk	FALSE
Daniel Higgins	FALSE
Miranda Dover	TRUE
Miranda Dover	FALSE

What I need is to condense each person down to only one entry. What I need to do is scan over repeated names, and if any of that person's enrollments is "TRUE" then I need to make a single entry with their name and "TRUE" enrollment. If they only have "FALSE" entries, I need to create a single entry with "FALSE" enrollment.

I know this is probably possible with a multi-row formula but I'm not quite sure how to do that.

[ArtApa · Accepted solution]

Hi @ltensmeyer - Here is a possible solution:

[ltensmeyer]

Exactly what I was looking for. Thank you!

[ltensmeyer]

@ArtApa I do have other columns with information that will be the same in each entry in them (birthdays, address, etc.) Any idea on how to also keep those in the end product?

[ArtApa]

@ltensmeyer - Most likely if you will add Group By in the first Summarize, it will work.

[ltensmeyer]

@ArtApa Perfect. Thank you!