SOLVED
Combine Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JingYih_Herbalife
8 - Asteroid
‎12-05-2021
06:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
4 REPLIES 4
21 - Polaris
‎12-05-2021
06:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@JingYih_Herbalife
I suppose your input is three sets of data.
‎12-05-2021
06:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎12-05-2021
08:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@JingYih_Herbalife
I tried to be dynamic and do hope there is better solution.
‎12-09-2021
01:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)