Converting a table into a rota/grid

I have a table that I am using to track staff activity.

Each row has 1 staff member and a date, so each staff member has 365 rows each for the year. There's then multiple columns determining the different types of activity they can be doing (there's then conditional formatting to check if these clash or to inform staff which should be cancelled when they do overlap etc.)

Is there a way to transpose or translate this into a more readable grid?

I imagine with enough nested if statements and an xlookup or something for the date and names, I could do it... something like this, where Special Activity goes first, but if it is blank, then whatever is in Activity, and so on through the different activity columns?

Does anyone have any ideas for a more elegant solution?