How to convert information from a Vertical View to a Horizontal View

Hi! I am looking for some assistance. I have a PTO tracker that colleagues fill in with their Paid Time Off and In Office/Work from Home days. I would like to be able to take that information (that is laid out in a Vertical view and put it in a horizontal view (please see below). I have attempted to link cells, but there is no way to link cells vertically to horizontally without doing each individual cell and that would be linking over 11 thousand cells manually. Any thoughts on how can achieve this easily? Thanks!

Kristie Diersen 😀