So, i need some help. I am moderately experienced with excel but i dont even know where to start with this one. I receive a district schedule from work every week in excel format. (the top spreadsheet) and i need it to "convert" into the lower spreadsheet to show a "at a glance" as to which store an employee is at for that day (don't care about the scheduled start and stop time, just the location/day/employee. This would be relatively simple if the spreadsheet always was exactly the same...but its not. Example would be for store 12345 sometimes has 2 employee scheduled at it or 1, or 3. This causes the merged cell with the store number on the left to always change. Any suggestions on how to start?
Bookmarks