Data Transpose Needed!

Hi there:

I need to change the format/structure of a raw data file to be able to use in some statistics software for my research work. It seems that the raw data need to be transposed for each firm. But it would take a long while to do it if I want to do it manually over and over again for hundreds of different firms. I was wondering if there is any mechanisms in excel to make it faster or automate the process to some extent.

I have shown here a simplified image of my intended format/structure of the data file. I hope you understand that the real raw data file has a lot of firms, a lot more items (14), and years(16). I have also attached a sample of the raw data file for you to have a look and understand the nature of the data file.

Excel Help.png

I would highly appreciate if somebody can help me out.

Thanks.

Sincerely,
Imran