I have a record of salaries in three columns - Empoyee, Date, Amount.

I am trying to use this to establish an annual salary for each pay day,
and Indexing is not working because the pay days are monthly and the
salaries are annual. To make looking up a salary easier, I have moved
the salaries into Year columns, as below:

Employee Date Salary Jan-04 Feb-04 Mar-04 Apr-04 May-04
1000 Jan-04 5000 5000
1000 Feb-04 5200 5200
1000 Mar-04 5400 5400
1000 Apr-04 5600 5600
1000 May-04 5800 5800
1000 Jun-04 6000
1001 Jan-04 2500 2500
1001 Feb-04 2600 2600
1001 Mar-04 2700 2700
1002 Feb-04 4000 4000
1002 Mar-04 4500 4500
1002 Apr-04 4750 4750

I now need a method to move all the salaries of each employee into a
single row.

Thanks in advance.


--
CharlesF
------------------------------------------------------------------------
CharlesF's Profile: http://www.excelforum.com/member.php...fo&userid=8743
View this thread: http://www.excelforum.com/showthread...hreadid=504575