Transforming yearly column entries into row variables

[Galaxorian]

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!

 

[sandy666]

but your assets, employees, revenue and RandDexpense are not available on the picture
what about Data Year - Fiscal? All in one cell?
use XL2BB to post representative example with generic data and expected result

 

[sandy666]

something like this?

Company Name	Ticker Symbol	CUSIP	CIK Number	Global Company Key	ISO Currency Code	Fiscal Year-end Month	Data Da	Data Year _ Fiscal
ABBOTT LABORATORIES	ABT	2824100	1800	1078	USD	12	20001231, 20011231, 20021231, 20031231, 20041231, 20051231, 20061231	2000, 2001, 2002, 2003, 2004, 2005, 2006