Thread: Pivot Table ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Big John[_2_] Big John[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.