Multiple Records Into A Single Record...

[aljordan]

I have about 800 records that look like this:

id diag
0001 11.0
0001 4.56
0003 10.5
0003 41.7
0003 52.5


I want it to look like this:

id diag1 diag2 diag3
0001 11.0 4.56
0003 10.5 41.7 52.

 

[Guest]

Have you tried using a pivot table?