Need to Transpose and Flip Table of Data - Macro Probably Needed

Hello All,

I am a longtime user of excelforum, but I haven't thought about posting until now. I'm hoping you can help with an issue I'm having.

On a monthly basis I receive a table of data that has 24 rows and columns. Once I receive it, I manually transpose and flip the columns and rows. My hope is that one of the VBA superstars on the forum can write a macro to do this automatically. I have attached a workbook that shows the before (how I receive the data) and after (how I'd like it to look after using a macro). It's hard to explain without looking at the workbook, but normal transpose functions don't seem to work here.

Any help would be greatly appreciated!

Best,
Bob