Hello! I'm looking for some help with some sort of formula or way to quickly automate the following:
I have a long list of time records for an employee that I'd like in a different format. Currently they're like the left side of below, when I'd like them to look like the right (single row per date worked).
This seems straightforward enough with some sort of vstack or hstack shenanigans, but I don't fully understand those yet. As a bonus, if we could then figure out how many weeks a person worked from the dates on the right range, that would be great too.
Bookmarks