How to combine the same ID object into a single row

[Guest]

Hi,

I have a query result like below, and I would like to combine the Same ID
object into signle row. In another word, I will only have one row for object
A and one row for object B. (For example: Object_ID Avg of 2C19 Avg of
2C9 Avg of 3A4 ..)


Object_ID Enzyme Avg
A 2C19 6.05
A 2C9 10.41
A 3A4 35.64
B 1A2 100
B 2C19 10
B 2C9 0.35
B 2D6 125
B 3A4 8.45

 

[Guest]

I think this is what you want --
TRANSFORM Min(Object_Enzyme.Avg) AS MinOfAvg
SELECT Object_Enzyme.Object_ID
FROM Object_Enzyme
GROUP BY Object_Enzyme.Object_ID
PIVOT Object_Enzyme.Enzyme;