Turning one column into different columns

[Alexandra_Pops]

Hi, all

Is there any way you could help me with organizing the data from 1 column into 3 columns with their specific info below? 

As you can see in image attached, I have a Column - New Field which holds all my information.

I need three columns "Cognome e Nome" ||| "COD. GIUSTIFICATIVI..." ||| "VOCI MENSILI" and below each of them I would need to have the specific details "Cognome e Nome" - "Accardo Massimo", "Alessi Fabio"... then below "COD. GIUSTIFICATIVI" -"310FERIE... ", "307BANCA", "Donazione Sangue" then "VOCI MENSILI" - "4,00 ROL..", "10,00 ROL"

*Sometimes COD GIUSTIFICATIVI will have 1 line below it, sometimes 2, other times 3 .. meaning that I cannot come up with some rule that would always take a hardcoded number of rows below the one that I need as header.

It would be more like a Until find value "VOCI MENSILI" have rows above numbered x.a x.b etc. and place them under x I guess .. 

Would highly appreciate any help! 

Thanskies, 

Alex

[atcodedog05 · Accepted solution]

Hi @Alexandra_Pops 

Here is how you can do it. For added rules please provide sample input data and expected output in an excel file.

Workflow:

Hope this helps : )

[Alexandra_Pops]

Hewwo, @atcodedog05 

Amazing! it works and u saved me sooo much trouble and it will be so helpful for my future workflows. so nicely done and so quick. 

Thank youuu! 

Have le nicest day! 

Alex

[atcodedog05]

Happy to help : ) @Alexandra_Pops 

Cheers and have a nice day!