Here is my gsheet: https://docs.google.com/spreadsheets/d/1EnAJt4K1lHhtQrjulEWjGejFcNwnqKK-o-GBXZvro2k

In B2 of the RepData , I have pulled in all the data from the 2 reps (Joe & Robert).
={ARRAYFORMULA(Joe!A2:C4);ARRAYFORMULA(Robert!A2:C4)}
However I would like for each line I pull from the rep’s data to first prepend the rep’s name.
How can I do that?

Thank you, EJ

I tried:
={{“Joe”;ARRAYFORMULA(Joe!A2:C4)};{“Robert”;ARRAYFORMULA(Robert!A2:C4)}}

I can’t figure out how to insert a (column/cell) value per arrayformula row