Traspose and flag column in a table

[Anonymous]

Hi,

I am trying to find a solution for below problem.  I want to replicate my input and add flag columns. Here is my data:

Col1 Col2 Col3 Col4 Col5

aa    bb     cc    dd     100
aa    bb     cc    ee      200
aa    bb     cc    ff      400

Output:

Col1 Col2 Col3 Col4 Col5 dd  ee ff

 aa    bb     cc    dd     100  Yes No No
aa    bb     cc    ee      200   No Yes  No
aa    bb     cc    ff      400    No No Yes

Thanks in advance.

[DataZoe · Accepted solution]

@Anonymous In Transform Data, or Power Query, click on the Col4 and then choose Transform --> Pivot Column. (If you want both columns, you can right-click and duplicate the Col4 first, then pivot it.)

Let me know if that works for you!