Orbis databse to panel data

[dbven]

Hi,

I gathered data from database Orbis, but the output is unusable in this form.
I need panel data. I uploaded an example of my data and a example how i need it.
The data is way too much with too much variables to do it by hand with special pasting.

Please help! any tips??

[oeldere]

with index / match.

See the green cells in the attached file.

[newdoverman]

This is very awkward data to work with. There are too many formulae to list here.
I started off by listing the companies repeated the number of columns to be retrieved.
Next, I assigned the years manually to the rows that were to have data relating to years and copied the range and filled down the length of the data.
The rest should be self-explanatory. I used the converted data to produce a pivot table.

I hope that the program that produced this data can be manipulated to produce data that is easier to work with.

[dbven]

Thankyou guys for looking at it!
The data is really akward yeah, but i cant change the size of output weird enough..
Im going to see if your advices help!

[dbven]

oeldere u are my hero!

[oeldere]

Thanks for the rep.

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

[dbven]

It helped me alot, but i cant use the same trick for another problem.
I need to add country codes next to the company names, because i need to add GDPgrowth rates to the countries.

Here is an example how i need it and the companies with their codes. (real dataset is way bigger so manual editing isnt possible).

I have tried the INDEX but i cant make it work...
Could u help me again?

[dbven]

Could u please take a look at my other problem? posted below. Its almost the same but i can't fix it.