Formatting a join table

[msbCytology]

Hi. I'm developing a database for a collection of algae samples. My issue of the moment involves exporting a join table as an excel spreadsheet. The join table has the following fields:

Join Key

Sample ID (foreign key from site description)

Species name (and foreign key from species list)

number of cells/sample

I'm trying to export all of the records in the join table into an excel spreadsheet such that each unique sample ID heads a column and each unique species heads a row, with the count value occurring at the site-species intersection.

Any help would be really appreciated,

N.

[comment]

Filemaker does not do cross-tabs natively. Since you are exporting to Excel anyway, it would probably be best to do it there.