View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phd4212 phd4212 is offline
external usenet poster
 
Posts: 12
Default Tabulating a large list

So here is my problem. I am supposed to create a tabulated table comprising
multiple different criteria for multiple people. Here is an abbreviated
version of what I am working with:
Bob 1 Cars January
Bob 2 Trucks January
Bob 1 Cars February
Jack 2 Cars January
Jack 2 Trucks February
Jack 1 Cars February
Bob 4 Trucks February
Jack 5 Cars January

Trying to get it into this format:

Employee Month Cars Trucks
Bob January
Jack January
Bob February
Jack February

Thanks