Turn rows into columns

[Ocasio27]

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 · Accepted solution]

@Ocasio27 

You may pivot the table as

[#3]

@Ocasio27 

That's a simple pivot table.

Person number in rows area.

Yes or no in columns area.

Count in values area.