Convert table format to a different kind

[Guest]

May I know, what feature that I need to use (query, functions etc) to
convert Table A to the format of Table B

Table A
Time Curve Values
0 A 10
1 B 20
2 C 30
0 A 40
1 B 50
2 C 60
0 A 70
1 B 80
2 C 90


Table B
Time CurveA CurveB CurveC
0 10 20 30
1 40 50 60
2 70 80 90

Thanks

 

[Douglas J. Steele]

You should be able to do that using a crosstab query. Create a new query,
select that option and follow the instructions.