Reorganize a data set

Hi everybody,

I am currently writing my master thesis, for this I need to perform data analysis.
The data team of my university has provided me with a data set for several variables for thousands of companies, through out several years.

Very handy, however the organization of the data makes it impossible for me to use it.

Therefore I want to reorganize the data, I started by doing it manually, but after 4 hours I am hoping to find an easier method.

To explain what I want to do, I have included an attatchment. I hope the colours inserted make my intentions clear..

I expect it should not be to complicated, but I am just a beginner in excel and my skills are therefore very limited.

Hopefully someone can help me with this!

Thanks!!

This may seem a bit weird but it works
First add a header to the Company Column

1) Start the wizard -- Data/PivotTable & PivotChart Report...

2) Step 1 of 3 - Select Option Button: Multiple Consolidation Ranges -- [Next]

3) Step 2a of 3 - Select Option Button: I will create the page fields -- [Next]

4) Step 2b of 3 - With your cursor in the Range Textbox, select the data range on your sheet that you want to normalize -- [Add] -- [Next]

5) Step 3 of 3 - [Layout...]

6) Drag the Row and Column buttons OFF the Layout -- [OK] -- [Finish]

7) Mysteriously, you are on another sheet that has a 4-cell pivot table. Double click the BOTTOM RIGHT CELL

8) Again, on another sheet -- This is you data normalized, or at least closer to it. You'll need to change headings at least.

Just delete the column containing company names and you're ok

(extract from www. tek-tips.com)

Thank you very much!
It worked perfectly!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save