Get & Transform: changing shape of data

[Graemea]

Hi,

I have data in a Table in A1:E5 and would like to use Power Query to transform the data into the form shown in G1:M3.

Can someone please tell me how to do this?

Thanks very much!

 

[sandy666]

Product	Sales	Cost	Profit	Region		Product	EUROPE Sales	EUROPE Cost	EUROPE Profit	ASIA Sales	ASIA Cost	ASIA Profit
AAA	100	50	50	EUROPE		AAA	100	50	50	300	150	150
BBB	200	100	100	EUROPE		BBB	200	100	100	400	200	200
AAA	300	150	150	ASIA
BBB	400	200	200	ASIA

 

[Graemea]

Thanks very much

 

[sandy666]

You are welcome & thanks for the feedback