Split a column into multiple

[Venamma]

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

[binuacs · Accepted solution]

@Venamma One way of doing this

[Connect_Rehan]

You can use this: