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...