I am currently having a problem trying to create a database like output from excel. Unfortunately, I do not have Microsoft access which would solve the dilema quite easily I believe.

I currently have data that is in 3 sheets. Each represents financial data pulled from different time periods for roughly 600 accounts.

The data is organized as follows:
column A : account name
coulumn B : FYE date
column C : Revenues
Column D : Working Capital
etc ...
(with different column titles representing various financial values)

I am having 2 different issues:

1. There are repeated FYE dates and therefore repeated data from one sheet to annother. This is for a small percentage of the accounts.

2. I would like to produce a pivot table (or similar table) that would allow the user of the report to see the data for each account and subsequently any of the financial values juxtaposed year over year.

I guess I would like to see it like this if possible:
2010 2009 2008 2007
Acct 1
Revs $10 $12 $10 $9
WC $6 $5 $4 $3
Acct 2
Revs $15 $16 $9 $14
WC $1 $4 $3 $6



Any help/advice would be greatly appreciated!