This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi,I'm working with an excel file that contains each employee's hours, as well as the associated work code for those hours. The table looks a bit like this...
I want to modify this table so that each employee has a unique row for each of the 4 work codes, even if they work 0 hours on that code. It should something like this:
Any tips on how I can get to this?Thanks!
Hi @aidanf ,
Here is a workflow for the task
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
First, using summarise tools to make the complete list of Names and Work Codes
Next, using append fields to create a full set
A join multiple tool allows for creating an outer join to make the full table
Finally, a multi-field formula allows filling in the NULLs
Have attached a sample
I would suggest a more dynamic approach that would pick up any work code, even if that is greater than that you used in your example
Let me know if that works for you or if anything is unclear.
@jdunkerley79 That's a great approach, couldn't get the Join Multiple tool to work for my workflow, but now I know why. Thanks for that, great solution!
Thank you so much for this suggestion, it works really well with my workflow.