i have the following requirement. my table has following records

DOW_ID | BEGIN_VAL | END_VAL
----------------------------
1 | 11 | 11
1 | 21 | 21
2 | 12 | 12
2 | 22 | 22
3 | 13 | 13
3 | 23 | 23
4 | 14 | 14
4 | 24 | 24
5 | 15 | 15
5 | 25 | 25
6 | 16 | 16
6 | 26 | 26
7 | 17 | 17
7 | 27 | 27

I want to display the records in the following way


1 2 3 4 5 6 7

11 11 12 12 13 13 14 14 15 15 16 16 17 17
21 21 22 22 23 23 24 24 25 25 26 26 27 27

can anyone help me achieve this requirement.

This is very smilar to a previous request you had.
Try:

DEFINE FILE Fn
FLOW/I1=IF DOW_ID EQ LAST DOW_ID THEN 1 ELSE 0;
END
TABLE FILE Fn
SUM BEGIN_VAL END_VAL
ACROSS DOW_ID AS ''
BY FLOW NOPRINT
END

Sorry alan i forgot to mention that i am storing in a table temporarily and reading it later from that and displaying.

The basics should be the same:

DEFINE FILE Fn
FLOW/I1=IF DOW_ID EQ LAST DOW_ID THEN 1 ELSE 0;
END
TABLE FILE Fn
SUM BEGIN_VAL END_VAL
BY DOW_ID
BY FLOW
ON TABLE HOLD
END

TABLE FILE HOLD
SUM BEGIN_VAL END_VAL
ACROSS DOW_ID AS ''
BY FLOW NOPRINT
END

Is this any help, what you are looking for?