Combine Data

[JingYih_Herbalife]

Hi,

I have data such as below where each country has a different quantity for different quantities. 

I would like to transform the data into as per below. 

Can anyone please guide on what is the best way possible to achieve this?

Thanks in advance. 

[Qiu]

@JingYih_Herbalife 
I suppose your input is three sets of data.

[JingYih_Herbalife]

Hi @Qiu ,

Thanks for the solution above. Is there a solution if the input is all in one data set?

[Qiu · Accepted solution]

@JingYih_Herbalife 
I tried to be dynamic and do hope there is better solution.

[JingYih_Herbalife · Accepted solution]

Hi @QI 

This worked great.

Thank you very much 🙂