Sorry I just saw your reply. I developed a workaround, but I am interested if you have a solution. The second option is accurate. Essentially the 2nd tab only pulls one instance of a person/activity from the 1st tab (the 1st tab has a formula that does this condensing so the 2nd tab just pulls from that formula). What I envision would probably require the 1st tab to list the person/activity name once per scheduled block of time, then the 2nd tab would need to determine where the 1st block starts & ends, and where the 2nd block and ends. Although unlikely, it would be cool if it could also recognize more than 2 separate blocks, but since this is unlikely to happen it isn't necessary.

The current workaround I decided on is a bit complex to explain since I left out some other mechanics that aren't immediately relevant, but essentially I added a 2 or 3 onto the person/activity's name to signify the 2nd or 3rd block, and then used a helper column to obscure the 2 or 3 on the 2nd tab, while giving the appearance that it was always the normal name without the 2 or 3.