Converting a Data List into a table.

[Guest]

I'm new to Access and not sure of what its capabilities are. I have an Excel
spreadsheet that contains the following data (this is a simplified example):

Event Location Date Name
A Here 9/18 Johnny
B There 9/19 Debbie
C Over there 9/20 Johnny
D Some where 9/21 Debbie

And I would like it to look like:

Johnny Debbie
A 9/18 Here
B 9/19 There
C 9/20 Over There
D 9/21 Some where


Would Access be able to convert my lists into a table format? I would love
to do it in Excel, similar to a Pivot Table, however, when I place a field in
the data section, I'm not trying to compare numbers, I want the text to show
up and that isn't possible I guess.

Please let me know if I should investigate doing this in Access.

Thank you,
Valerie

 

[Duane Hookom]

You should be able to create a crosstab query with Event and Date as Row
Headings, [Name] as the column heading, and First of Location as the value.

BTW, Name and Date are not good field names since Name is a property of
every object in Access and Date is a function.