That is easy to do with a pivot table...

Select the data you want to summarize in a table (make sure the source data
has headers for each column). Select Data |Pivot Table and Pivot Chart...
When the wizard opens just select Finish. For a simple pivot like this XL
will make the correct choices on your behalf.

A new sheet will be created with a pivot table on it. Each of your column
headings will show up on a Field List. Drag the Employee Names to the left
hand column. Drag the Months also to the left hand column next to the
employees. Drag the numbers to the data area. Drage the Cars/Trucks to the
top row.

You can also apply an outo format to the table to make it all pretty like.
It will amaze and impress your friends.
--
HTH...

Jim Thomlinson


"phd4212" wrote:

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