Convert Table Schedule to Personal Schedule

I'm trying to add a secondary display for a work schedule. Our primary schedule lists location on the leftmost column and time of day on the top row. The cells in-between have the name of the staff person assigned to that specific location during a particular hour. Yes, we move around a lot, staff prefer that. What I would like to do is have a secondary display option that lets someone select their name to popup a simple view that shows where they are each hour of the day. I had assumed the answer would be a pivot table, but I'm not really finding ways to treat column 1 as an x-axis. Excuse the lack of any semblance of formatting, this is just for proof of concept:

Primary schedule on left, sample pop-up schedule on right.