software

Hi,

I have a list of source data that I need to change to format of and I
am not sure how to do it. Maybe a pivot table? What I want to do is
have each Pers. No. and name displayed in only one row. Then I want the
other date amp; date type pairs displayed in the columns next to Hire date.
So each employee will have multiple columns of dates and date types.
Does anyone know how to do this? I tried a pivot table but I dont want
to do any calculations with the data... I just want to display it and I
cant find a way to get Excel to do that. I would greatly appreciate
anyones help!

Thanks,
Adrianne

Pers.No.Personnel NumberDateDate type
5Hopkins , Kevin11/17/1998Hire Date
5Hopkins , Kevin11/17/1998Adj Service Date
5Hopkins , Kevin01/19/1999Rehire Date
5Hopkins , Kevin01/19/1999Vac Accrual Date
7Zinis , Anthony F04/18/2000Hire Date
7Zinis , Anthony F04/18/2000Adj Service Date
7Zinis , Anthony F04/18/2000Vac Accrual Date
9McTyre , Mark01/24/2000Hire Date
9McTyre , Mark01/24/2000Adj Service Date--
Adresmith
------------------------------------------------------------------------
Adresmith's Profile: www.excelforum.com/member.php...foamp;userid=9131
View this thread: www.excelforum.com/showthread...hreadid=504582Adrianne -
If each Date Type can have only one entry per person (i.e., someone
can't have two Rehire Dates), you can use a pivot table. Follow the
pivot table wizard and

Drag Pers.No to the left most column (set field settings subtotal to
none)
Drag Name to the column area adjacent to Pers No
Drag Date Type to the top Column area
Drag Date to the data area. This will likely default to a count.
Change it to sum and change the format to date.
Under Table Options, turn off grand totals for rows and columns

This should get you going. As mentioned it only works if there is a
max of one entry per date type. If there is two, then the date shows in
the table will be significantly off...the year would be in another
century.

- John Michl
www.JohnMichl.com