Power BI Transformation

[Anonymous]

Hi,

I have one excel in below format.

Available Data
	1/1/2021	1/2/2021	1/3/2021
India
Total Cases	100,000	200,000	300,000
Total Hospitals	2,000	3,000	4,000
Indonesia
Total Cases	10,000	20,000	30,000
Total Hospitals	200	300	400

I want in below format. i tried using power query but i am not able to get it.

Date	Country	Total Cases	Total Hospitals
1/1/2021	India	100,000	2000
1/2/2021	India	200,000	3000
1/3/2021	India	300,000	4000
1/1/2021	Indonesia	10000	200
1/2/2021	Indonesia	20000	300
1/3/2021	Indonesia	30000	400

[Anonymous]

Hi @Jihwan_Kim ,

Thank you very much for your elegant solutions.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the link down below. It is a short video of my computer screen capture.

https://www.dropbox.com/s/8gnmqknnv2orwux/New%20video.mp4?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.