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
Solved! Go to Solution.
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!