Forum Discussion
transformation rows into columns
Hello everyone, I am working on an Excel file with rows that have sub-rows, I would like to do a transformation by bringing these sub-rows into columns. Each month we will have a file of this fo...
Hello spinfuzer,
Thanks you.
But, the sub rows contains "/" is excluded.
Is it possible not to exclude sublines that contain "/"
thanks
https://www.dropbox.com/scl/fi/rwe9m0fm236uyly9njp64/data.xlsx?rlkey=95pkam4g7qw72jd1q8asanepy&dl=0
Hello alsolok ,
DId you follow the entires set of steps? We purposely did not include the other rows because we are trying to do a fill down on the rows with "/".
1) Copy only the first rows to another column (in this case we use ends with "/" otherwise null)
2) Fill down those rows
3) Filter out the first rows
4) Create index starting from 0.
5) Transform index modulo 2.
6) Pivot on Index and do not aggregate on the "Prenom / Projet / facturation" column.
7) rename and reorder your columns as desired.