Transpose Some Columns to Rows - SQL Server source

[monibuw]

I am working with a set of demographic data and my data source is on SQL Server. To properly analyze and visualize it in Power BI, I need to transpose some columns into rows, preferably in a new table. I appreciate any recommendations to do that either in Power BI or in SQL server.

Here is how my data currently looks like:

This is how I would like it to look like: 

I have imported a portion of the data into Excel to provide the above screenshots.

[amitchandak · Accepted solution]

@monibuw , Use unpivot in power quey 

https://radacad.com/pivot-and-unpivot-with-power-bi
My Video

https://www.youtube.com/watch?v=2HjkBtxSM0g