May 27 2021 08:09 AM
I am trying to do this in Power Query, left side of this table to the right side of this table
Person number | Yes or no | Count | Person number | TRUE | FALSE | |
Person1 | False | 1 | Person1 | 2 | 1 | |
Person1 | True | 2 | Person2 | 1 | 0 | |
Person2 | True | 1 | Person3 | 10 | 13 | |
Person3 | False | 13 | Person4 | 8 | 9 | |
Person3 | True | 10 | Person5 | 25 | 11 | |
Person4 | False | 9 | ||||
Person4 | True | 8 | ||||
Person5 | False | 11 | ||||
Person5 | True | 25 |
May 27 2021 08:19 AM
SolutionMay 27 2021 08:20 AM
That's a simple pivot table.
Person number in rows area.
Yes or no in columns area.
Count in values area.
May 27 2021 08:19 AM
Solution