Transform a table

[Vids]

Hi,

Please help in transforming old table to new table (as given below) in Power BI. Is there any way that I can run a query to transform old table to new table automatically?

Old table
	Project A	Project B	Project C	Project D
A	Yes
A		Yes
A				Yes
B	Yes
B		Yes
C			Yes
C				Yes
New table
	Project A	Project B	Project C	Project D
A	Yes	Yes		Yes
B	Yes	Yes
C			Yes	Yes

[Bifinity_75 · Accepted solution]

Hi @Vids , you need to do the following. In Power Query:

- You have this table:

- Select Column "Column", and unpivot other columns:

- Select column "value" and filter only "Yes" like the image:

- Select column "Atribute" and select dinamic column:

- Last,  Select this values in options for the dinamic column:

The result:

Best regards