Forum Discussion
Solved
Turn rows into columns
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 |
2 Replies
That's a simple pivot table.
Person number in rows area.
Yes or no in columns area.
Count in values area.
