Need Help!! for Loop

[sahernandez]

Hi, I have this information
FREC orden Estacion DEMORAS TIPO
1 2 BOG -5 SOLO-93A
2 2 BOG -1 SOLO-93A
3 2 BOG -2 SOLO-93A
1 2 BZE -3 SOLO-93A
2 2 BZE -2 SOLO-93A
3 2 BZE -1 SOLO-93A
1 3 BOG 0 93A +OTRAS
2 3 BOG 0 93A +OTRAS
3 3 BOG 2 93A +OTRAS
1 3 BZE 0 93A +OTRAS
2 3 BZE 0 93A +OTRAS
3 3 BZE 0 93A +OTRAS
1 4 BOG 3 Demora Directa
2 4 BOG 1 Demora Directa
3 4 BOG 3 Demora Directa
1 4 BZE 0 Demora Directa
2 4 BZE 0 Demora Directa
3 4 BZE 0 Demora Directa



And I need to put it like this:

tipo frec1-2 frec2-2 frec3-2 frec1-3 frec2-3 frec3-3
SOLO-93A -5 -1 -2 -3 -2 -1
93A +OTRAS 0 0 2 0 0 0
Demora Directa 3 1 3 0 0 0

Can somebody help, I need to do this on ASPX page, for plot this information into a CHART.

Any Idea.
Thnxs
Alexander

 

[ceyhorn]

Is this a table in the database? Could you please describe what you are trying to do and why.

Chris