Galaxorian
New Member
- Joined
- Sep 30, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
I have another question concerning the formatting of data (see the picture). The file in question contains information on about 260 unique companies. However, I want to structure the data in such a way that for each company there is a single row and multiple columns on for example Assets2000, Assets 2001 etc. I want to do this for assets, employees, revenue and RandDexpense. The issue is that the data range is from 2000 to 2006 so most companies have 7 rows, but some are missing a few years and have 3 rows. How do I go about getting the data in the wanted format?
Thanks a ton!
I have another question concerning the formatting of data (see the picture). The file in question contains information on about 260 unique companies. However, I want to structure the data in such a way that for each company there is a single row and multiple columns on for example Assets2000, Assets 2001 etc. I want to do this for assets, employees, revenue and RandDexpense. The issue is that the data range is from 2000 to 2006 so most companies have 7 rows, but some are missing a few years and have 3 rows. How do I go about getting the data in the wanted format?
Thanks a ton!