complex data into organised table?

[marquee.moon]

hello,
I have been provided with some chemical anaylsis data in the following format: date / analysis type / value
There are 20 different types of analysis
Not each analysis is done on the same day, some are, some aren't
So for some analysis, I have hundreds of dates (and therefore hundreds of lines of data), for others I only have a few (and these dates may not be replicated in other analysis)
There are over 12,000 lines of data
I would like to turn my data into something that looks like this:

DATE_______ANALYSIS 1________ANALYSIS 2________ANALYSIS 3
1/1/00______0.4____________________________________________
2/1/00______0.7_______________334_______________3_________
3/1/00________________________340_______________4_________

how can I go about this? (excel 07)
I've tried pivot tables, but cant get it to just give me the values, it wants to tell how many values I have, so I get a load of 1's and 0's instead.
Any advice greatfully recieved.
thanks,
mm

[Alf]

I think you need to upload a sample file with some of the data and also show how you wish it organized.

Alf

[marquee.moon]

OK, but the data's on my work pc, which I'll be able to access on Tuesday.

[thebellguy]

It sounds like you may just need to change the pivot value field settings to SUM or MAX instead of COUNT.

[marquee.moon]

I've sorted it out.
I'd previously tried to do a pivot tablek, but the SUM & MAX opions didnt work.
It turns out that this was because I had done an 'IF' statement on the data that showed a ">" value in one of collumns (to replace with zero). This resulted in the concentrations being read as text, rather than numbers, so the pivot table couldnt deal with them.
A friend showed me a different way of handling the ">" values to keep them as numbers and now the pivot table (using "AVERAGE") works perfectly.

Thanks,

mm