Extracting data in Excel 2007

[Jo]

I'm new to Excel 2007. In previous versions (probably at least 2 versions
ago), I used to be able to do a data query that would extract data records
based on specified criteria. I can't for the life of me figure out how to do
that in Excel 2007.

Here's an example of the format my data is in:

CLIENT DATE REP
client1 01-Apr Jane
client1 12-Apr Jane
client2 02-May Jane
client3 15-Jun Jane
client1 07-May Mary
client3 20-Apr Mary
etc.

Ideally what I want to do is set up a report like this below for each rep. I
don't see anything about Pivot Tables to know if it will do this or not, and
I'm having trouble playing around with them to find out. Database functions
only seem to want to compile statistics (totals of amounts, counting the
number of records, etc.), which is not helpful for this.

Jane client1 client2 client3
01-Apr 02-May 15-Jun
12-Apr

What I'd settle for is this below, which I used to be able to create using a
data-extract:

client1 client2 client3
Jane 01-Apr 02-May 15-Jun
Jane 12-Apr
Mary 07-May 20-Apr

Can anyone advise me how I can put either of these together in Excel 2007? I
would appreciate any help you can give me. Thanks very much in advance!