Page 1 of 1

How to display multiple rows data in single row

Posted: Fri Jul 02, 2010 8:48 am
by 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,

Posted: Fri Jul 02, 2010 9:12 am
by anbu
Search the forum for "Vertical Pivot"

Posted: Fri Jul 02, 2010 9:12 am
by Sainath.Srinivasan
:idea: If it is just 2 rows, you can manually edit the file.

You can use space as record delimiter.