I am trying to select multiple rows from one row in a source sheet based on another column in the source sheet. E.g.:
Name Start Add Bob 2012-01-01 01:01:00 10:00:00 Tim 2020-01-01 01:01:00 04:00:00
And what I am looking for in the output is something like:
Bob Tim 2012-01-01 11:01:00 2020-01-01 05:01:00 2012-01-01 21:01:00 2020-01-01 10:01:00 2012-01-02 07:01:00 2020-01-01 15:01:00 ...
I'm not sure how to do this, if it's possible... I've been working on getting the time modification done (which also isn't intuitive) but I realized I also don't know how to repeat and pivot the results.