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

It sounds like your data with just 3 columns was set up perfect for a
pivottable.

Select you data (A1:Cxx)
data|pivottable
follow the wizard until you get to a step with a Layout Button on it.
Click that button
Drag the employee id number field to the Row field
drag the date field to the column field
drag the Salary field to the Data field
(if it doesn't say "sum of", double click on it and choose Sum.

And then finish up the wizard.

CharlesF wrote:

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

--

Dave Peterson