Pivot Table ?
I have a list of Employees and the year they started as follows:
Employee Year
John 1998
Betty 2001
Sam 1985
Joe 1998
Pete 2001
I would like to create a list like this:
1985 1998 2001
Sam John Betty
Joe Pete
I tried to use a Pivot Table, but I cant get the names in each column.
Any suggestions would be appreciated.
Thanks in advance.
|