SOLVED
Comma separated values into the new 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
GouthamVijay
7 - Meteor
‎06-09-2022
11:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey Folks,
Whenever there are values which is separated from the comma then it has to be entered in the next row...
Input:
Expected Output:
Regards And Thank You
Solved! Go to Solution.
Labels:
4 REPLIES 4
16 - Nebula
‎06-09-2022
11:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check out the Text to Columns Tool. There's an option to split to rows.
15 - Aurora
‎06-10-2022
12:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please see below :
Text tocolumn with Split to rows :
Data cleansing to remove leading white space.
Attached the workflow,
Regards,
flying008
15 - Aurora
‎06-10-2022
11:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
13 - Pulsar
‎06-11-2022
12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @flying008!
Love that you responded with a gif! I never considered doing so, but this brings the solution to life!
