csv change shareasale

The datafeed information is sorted like this accoring to ShareASales'website. ProductID|Name|MerchantID|Merchant|Link|Thumbnail|BigImage|Price|RetailPrice|Category|SubCategory|Description|Custom1|Custom2|Custom3|Custom4|Custom5|LastUpdated|status|manufact urer|partnumber|merchantCategory|merchantSubcategory|shortDescription|ISBN|UPC I want you to change it to one info a row and remove this pipe sepration also i need one more option of changing merchant id number in the big list ... of csv please bid and will explain more