Where to begin with bi-variable table references?

I am trying to consolidate and categories data from one table (raw data output) into another table. Basically time stamps into a weekday ledger. I'm drawing a complete blank on how to begin. I'd like the completed sheet to consolidate entry names (staff) into one line, then add the hours earned each day and list them under the corresponding day of the week (Sun-Sat). I want to put it into a table format so it can be a living spreadsheet. What's the best approach? Combination of Xlookup and match? I mostly use Excel365 but also the desktop app which I think is fairly current (post xlookup).