Hi,
I have a question about querying environmental data so that it is transposed (sort of).
I have an Access table with three fields, Element/Chemical, Date, and Result.
For example, I have:
Element Date Result
------- -------- ---------
Iron 2/1/03 10
Iron 2/2/03 20
Zinc 2/1/03 10
Copper 2/1/03 10
Zinc 2/2/03 20
This is a simplified version of the table that I'm working with. In the real table, I have little more than 130 different elements/chemicals and about 5000 records. Our company has developed some kind of data analysis tool to run in Excel but the data needs to be formatted differently.
Basically, I have to put it in this format:
Date Zinc Iron Copper
2/1/03 10 10 10
2/2/03 20 20
In a sense, the data is sort of transposed, but the transpose function in Excel won't format it in this manner. Since there are only 130 different chemicals, I could probably do it manually, but just asking to see if there is an easier way. Any help would be appreciated. Thanks.
Everest
I have a question about querying environmental data so that it is transposed (sort of).
I have an Access table with three fields, Element/Chemical, Date, and Result.
For example, I have:
Element Date Result
------- -------- ---------
Iron 2/1/03 10
Iron 2/2/03 20
Zinc 2/1/03 10
Copper 2/1/03 10
Zinc 2/2/03 20
This is a simplified version of the table that I'm working with. In the real table, I have little more than 130 different elements/chemicals and about 5000 records. Our company has developed some kind of data analysis tool to run in Excel but the data needs to be formatted differently.
Basically, I have to put it in this format:
Date Zinc Iron Copper
2/1/03 10 10 10
2/2/03 20 20
In a sense, the data is sort of transposed, but the transpose function in Excel won't format it in this manner. Since there are only 130 different chemicals, I could probably do it manually, but just asking to see if there is an easier way. Any help would be appreciated. Thanks.
Everest