How to display multiple rows data in single row

[nagarjuna900]

HI,

I have the data with two columns with two rows as follows.

IS_AVAILABLE_SRDR SRDR_COUNT

X 5
Y 6

The output required as follows.

IS_AVAILABLE_SRDR SRDR_COUNT IS_AVAILABLE_SRDR SRDR_COUNT
X 5 Y 6

How to get the above output.

Thanks,

[anbu]

Search the forum for "Vertical Pivot"

[Sainath.Srinivasan]

If it is just 2 rows, you can manually edit the file.

You can use space as record delimiter.