SOLVED
Split a column into multiple
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
Venamma
7 - Meteor
‎10-03-2022
10:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have to split a column based on a string value within the entire sentence in that specific column.
The data looks as below and I'm trying to achieve the result as shown in the second table. Can someone please help me?
Column |
:Option A Question: How concerned are you about your mental health? |
B: Question: How concerned are you about your mental health? |
Question: How concerned are you about your mental health: |
Expectation:
Col 1 | Col2 |
:Option A | Question: How concerned are you about your mental health? |
B: | Question: How concerned are you about your mental health? |
Question: How concerned are you about your mental health: |
Thank you in advance
Regards,
Venamma
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
binuacs
21 - Polaris
‎10-03-2022
10:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Connect_Rehan
6 - Meteoroid
‎10-03-2022
11:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator