Is there a way in Power Query to denormalize a table?

[Alex20850]

I have worked with Power Query before and thought there was a way to denormalize a table.

The original data is State and different ethnic groups as different columns with the rows with population for each ethnic group.

I would like the output to be three columns
State Ethnic group Population

 

[GraH]

Select state column, right click and from the context menu choose Unpivot other columns.

 

[Alex20850]

Thanks, that was exactly what I was looking for.