Splitting the data

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 -

Thank you in advance 🙂

Accepted answers

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

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

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

Thank you

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

I don't know the easy answer as well.

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.

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

That was smart! I really like this one 😀

Thank you so much 🙂