Turning one column into different columns

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

Datasets

Parse

Dynamic Processing

Accepted answers

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 : )

All comments

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 : )

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

Happy to help : ) @Alexandra_Pops

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15872

MarqueeCrew 13708

apathetichell 13703