Complicated Transpose Macro

Hello Geniuses,

I have a set of data that is set up like a matrix, I want that data to be converted with a macro so I can make a proper pivot table.

Please see attachment, this is just a sample, the real file has 300 dealers and 50 item numbers roughly, so I need to be able to manipulate the macro.

Any help would be greatly appreciated!