Hello everyone, I have a spread sheet which contains multiple row entries for
users with multiple columns for various settings. It looks something like
this:

Name Switch1 Switch2 Switch3 Switch4
Switch5

Bill True False False False
False
Bill False True False False
False
Bill False False True False
False
Mary True False False False
False
Joe False True False False
False
Joe True False False False
False
Joe False False False False
True

There are hundreds of entries for these users and I'm trying to capture this
on another sheet with each user listed once and all of the switch settings
which are true to show "True" else "False" (or blank):

Name Switch1 Switch2 Switch3 Switch4
Switch5

Bill True True True False
False
Mary True False False False
False
Joe True True False False
True

I'm guessing some kind of nested 'and' formula or a lookup but can't seem to
make anything work. Any help here would be appreciated, thanks!


--
If you can read this, thank a Teacher...
If your reading it in english, thank a Veteran!