Hi all, I'm new here out of necessity:
I have a heap of data that is in rows vertically, separated into tables by borders. Each table has a date and a day and night shift along with tasks and associated hours. What I need to do is get all the data into a new format, 1 row per unique Date, shift , ID combination. transpose tasks and allocate hours + some other stuff. The attached example is rather self explanatory I think.
Here is my example sheet:
Bellow due to technical issue
The sheet is largely sanitized of confidential data and been simplified, the principles are my issue. I think I may be over complicating it?
My approach: Get all dates populated downwards - copy until date changes. Then in the new data area, populate Date , shift and Id rows; then write a loop thing that checks each date, shift, Id combination for that task, if it finds it - allocate hours and then move to next task.
Let me know what you guys think.
Feel free to email your sheets with answer methods / formulas.
Bookmarks