Thoughts on Query Design for Table Taken off of Web

[engineer225]

Hi Everyone:



New to the forum. I have an issue where I have a very large table on the web that I need to create a query for to evaluate the data. I have designed the table on paper but since I'm new at Access I am struggling to figure out how to design the query with the raw data to get the output I want. Below is a representative look on how the raw data are when I copy one record from the web and paste into a spreadsheet:

Last Name, First Name - Organization Name
Title	Begin Date	Score	End Date
Manager	1/1/2014	16	2/1/2014

There are dozens of records that I want to be able to analyze. In my query, the important pieces of data are:

1. Organization Name
2. Score
3. End date (I'm specifically interested in seeing the end date in terms of month, the day is not important)

In my design, I would like the output to look something like this, where the numbers represent the "score":

Organization	Mar-14	Apr-14	May-14	etc.
Company 1	26	4	0
Company 2	20	8	4
Company 3	20	6	0
Company 4	0	2	0
etc.

Does anyone have any thoughts as to where I can begin in terms of setting up the raw data? There are hundreds of individual records similar to the example I gave and it would take multiple days to go through manually.

Thank you!!

[June7]

That looks like a CROSSTAB query. There is a query wizard to help.

Not seeing fields for Last Name, First Name, Organization.