Splitting the data

[Ekta]

Dear All, 

I am trying to split the below data, please help me with the formula to spilt it.

Input - 

Name of Student  :  Clara Max

Year of Attending  :  2019  ID Num : X123456X

Output - 

Name of Student	Clara Max
Year of Attending	2019
ID Num	X123456X

Thank you in advance 🙂

[Emil_Kos]

Hi @Ekta,

Do the data look like this or the name of the student is a column name. 

[Ekta]

Yeah correct, sorry i missed giving them the column name.

Thank you

[Qiu]

@Emil_Kos 
looking forward to your replay, since it turns out not easy to me. 🤣

[Emil_Kos]

Hi @Qiu,

I don't know the easy answer as well. 

Hi @Ekta 

I have prepared a workflow for you. First I generated additional rows that allowed me to work with the data more effectively. 

Rest is a combination of filters and formulas. 

[ArtApa · Accepted solution]

Hi @Ekta - Hope the attached workflow will work for you:

[Emil_Kos]

Hi @ArtApa,

That was smart! I really like this one 😀

[Ekta]

Thank you so much 🙂