Hi All,

I have a table like this and i need to display the data as in Point 2).

Can you guys please help? We need this for one of our application. Number of record per day 15000 records per day.

Point 1)
Transaction id Product id Serial number Reason

100 1 123456 ABCD

100 1 XYZR

100 1 222222



200 2 8768 GHFR

200 2 JAYEN

200 2 9876 AMRA

200 2 9999



The above data should be shown as shown below :

Point 2)

Transaction id Product id Serial number1 Serial number2 Serial number3 Serial number4 Reason1 Reason2 Reason3 Reason4

100 1 123456 222222 ABCD XYZR

200 2 8768 9876 9999 GHFR JAYEN AMRA

Thanks in Advance to all.