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.
@JingYih_Herbalife I tried to be dynamic and do hope there is better solution.
Hi @QI
This worked great.
Thank you very much 🙂
@JingYih_Herbalife I suppose your input is three sets of data.
Hi @Qiu ,
Thanks for the solution above. Is there a solution if the input is all in one data set?