Hi,
I have tried my luck with all kinds of transform tools to re-arrange my data but no luck.
This is the look of my current data set.
and I want the above to look like below. What would be the approach please. Thank you!
Solved! Go to Solution.
Hey @chiragpatel_1,
Does the double x mean that it is not present in the data set? Also why is Still on Hire not mentioned in the final result table?
If i understood well, you want something like this, right? (dummy data, just replace the input)
thank you, works perfectly, just one last bit, the length of hire, i can't seem to get the order presented in my second image on my post, sort dosen't seem to work. any other tips, thank you!