splitting one column into multiple columns based on site

[Guest]

Hi,

I have a table that has three columns: Site, temperature, and date. There
are 7 different sites and multiple records per unique site for any given
date. What I want is to convert this table into a table with 8 columns: 1
date column and 7 Site columns (actually temperature columns for each of the
7 sites), with temperature the value listed under each site column for that
given date. The reason for this is so I can then take into excel and easily
analzye date useing functions for summary and graphing purposes. Any help
appreciated.

thanx

 

[Allen Browne]

Please do not post multiple separate messages to different groups. Even if
you do get some good replies the discussion will be fragmented.

If you believe you have a valid reason for posting to multiple groups, post
one message with all target newsgroup names in it, so that it becomes a
single thread in the multiple groups.

 

[Guest]

OK, I didn't know you could post to all newsgroups with a single message. The
reason I did this is because I am not sure where this topic should go.
Apologies for the second post in the queries forum, that was a mistake...

Now can you answer the question?

 

[Allen Browne]

Answered under m.p.a.queries