Hi all,
I have this data challenge, and nobody seems to be able to find a way on how to automate it in Alteryx.
It is possible via Excel (involving Vlookups, some IF formulas, and lots of dragging down formulas), and I'd like to impress my Alteryx sceptical colleagues by coming up with an automated workflow.
So here's the challenge:
- The data in white is an extract from one of our systems. The merged cells aren't great, but that's an easy one to fix.
- What I am trying to achieve is to get "Staff code", "Period" and "Grade" next to the charged hours (I have manually done it in the yellow cells)
- So the cells in yellow are blank in the original extract, and I would like to wrangle the data to get it populated via a workflow (the desired end result is in tabsheet "Desired output").
Note that the original extract is several thousands of lines.
Seems an easy one at first sight, but many have struggled with it before.
Hopefully this community can astonish me once again?
