Exporting to excel in rows instead of columns

[carlyle]

Hi folks, (please let me know if I'm posting this in the wrong place)

I have a database in FileMaker 4, and I would like to export it to excel in a way that doesn't require the user to change the placement of the data (i.e. which cells the data gets put into).

Here are a few more specifics:

We use this database to track data such as pH, water temperature, etc. on several sites which are monitored on a monthly basis. Each record in the database is one site on one day--there are multiple records for each site, and multiple records for each day, but only one record for each "site-day" ... does this make any sense?

I want to export the data to excel for graphing, but when I export "Site #", "Date", "Water Temp", I get three columns, which I then have to manipulate in excel. (This looks like this:

Site # Date Value

Site 1 Date1 H20 temp

Site 1 Date2 H20 temp

Site 1 Date3 H20 temp

Site 2 Date1 H20 temp

Site 2 Date2 H20 temp

Site 2 Date3 H20 temp

If I can get the data to export as:

Date1 Date 2 Date 3 etc...

Site 1 temp temp temp

Site 2 temp temp temp

etc...

then the graphing part will simply be a matter of highlighting the table and labeling the series. Since we will have to do this for multiple variables (pH, conductivity, lead, and many others in addition to water temperature), it would be VERY nice if I could get it to export in this format...

But I can't figure out how to do it! I don't know if it's a flaw in the design of my database, a flaw in the way I'm exporting, or whether there's some trick I can do...

Any ideas?

Thanks so much...

Carlyle

[Zadkin]

This looks like a crosstab presentation of the data. I have used such crosstab queries in Microsoft Access. I think Excel has them also, look in help for Crosstab or PivotTable.

[carlyle]

This will work! You are brilliant, thank you.

[carlyle]

This will work! You are brilliant, thank you.

[carlyle]

This will work! You are brilliant, thank you.