Agregate data from multiple rows in one row
Use For XML Path..

select 
Merchant_contract,
OriginalOrderid,
Stuff(
(Select ','+ status from yourtable t2 where t2.Merchant_contract=t1.Merchant_contract
and 
t2.orderid=t1.orderid
For Xml Path(''))
,1,2,'') as status
---do similarly for other columns
from 
yourtable t1
group by 
Merchant_contract,
OriginalOrderid