Copy cells based on a condition

Hi,

I have a data set which includes the list of companies and their financial data. The format is like below

CompanyId, Name, Sales2010, Sales2009, Sales2009, Profit2010, Profit2008....

the list has a 2364 firms, and I would like to change the format to a time series data such as

Year, Company, Sales, Profit etc.
2010, a, 123.45, 234.56
2009, a, 121.23, 345.21
2008, a, 132.34, 212.21

Basically, I can manually move the data but i have more than 200 difference financial data for 2364 firms, and it is a very big work. I would like to have a small formula or macro, which will look at the column name of the existing table, and if it has the same character such as Sales, Profit etc and then also check the year number from the column number and then move to the right cell. For example, if the Sales2009 is in the G column on my table, then G02 will be 2365th row under the new Sales column.

help is very approciated.

thanks, ozgur