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.

  • TRANSPOSE() is sort of what I'm looking for, but I want multiple values for each input row...
    – Josh
    Mar 22, 2020 at 13:45
  • Are you looking for a single function formula or are you open to have multiple functions in your formula? Please add a link to a demo spreadsheet shared with anyone with the link. Mar 22, 2020 at 16:47

1 Answer 1


In Test_Sheet You'll find following formula for each name


Tried to make it for whole array, but SEQUENCE failed me to return array.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.