Row to Column Formatting for 5K Unique Rows

Hello,

What I'm trying to do seems simple but not when I try to 5K unique IDs. I have 5k hospitals all in row format. Each hospital has procedural volumes (counts) for 33 different procedures, with the procedures in column format. Example in first screenshot below. 

What I need to do is convert the rows to columns, but have that repeat for the 5K unique hospitals and 33 unique procedures with the procedures now in rows. Result would be example in screenshot 2 below. Any suggestions? Thank you!