SOLVED
Split data into rows
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
Shaaz
9 - Comet
‎12-20-2021
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've a data like below where Country is the column name.
I would like to see the data as below.
Solved! Go to Solution.
Labels:
1 REPLY 1
Luke_C
17 - Castor
‎12-20-2021
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Shaaz
You can use the text to column tool, which has a split to rows option - see below screenshots & attached workflow. I used a record ID to join the original records back for your desired presentation.