Rearranging large amounts of data

Dear excellers,

This is probably a very trivial problem but I could not find an easy way to word it so that I could search for a solution.

Basically I have information in the form:

Company A Company B Company C ...etc.
H1 H2 H3 H4 H1 H2 H3 H4 H1 H2 H3 H4
x x x x x x x x x x x x
x x x x x x x x x x x x
x x x x x x x x x x x x
...etc.

I have now added the company name to the left of the table (say in H0 column) and am looking for a way to easily move all the information under one set of headings, so that it will look like this:

H0 H1 H2 H3 H4
A x x x x
A x x x x
...
B x x x x
...etc.



Due to the large amount of information this would be a very arduous task if I was to do it manually by dragging the data around and so I was wondering if there is any way I could get excel to sort it for me?

Thanks very much in advance for any help!

Example.png