Rearranging row data into column headers for large file

[Mima]

Hi everyone -

Currently stumped on an Excel problem. I have a spreadsheet with a lot of data - over 4000 rows - and this is how it is structured:

Category 1

Store 1

Metric 1
Metric 2
Metric 3

Store 2

Metric 1
Metric 2
Metric 3

Store 3

Metric 1
Metric 2
Metric 3

Category 2
...
And it goes on for another few thousand rows

Instead I would like to get "Metrics" as column headers - this should save a considerable amount of space. For example, like below:

Metric 1 Metric 2 Metric 3

Category 1

Store 1
Store 2
Store 3

...


How would you guys suggest the easiest way to do this would be (other than manually copying and pasting values )

[Russell Dawson]

Please post a sample workbook.

[Mima]

Attached the sample workbook

[darknation144]

Do you still need help with this?