Hi Guys,

We need to write a C code to sort source file based on Product no ,price and then create a new one with a specified format.

Below is the sample data of source file.

Product No. name Country Price Start date End date 101 A US 399 1/1/2011 31-12-2011 102 B UK 499 1/2/2011 31-12-2012 103 C AU 599 1/3/2011 31-12-2013 101 A GB 1099 1/4/2011 31-12-2014 104 D IND 1199 1/5/2011 31-12-2015 101 A UAE 999 1/6/2011 31-12-2016 102 B US 699 1/7/2011 31-12-2017 102 B UK 799 1/8/2011 31-12-2018 101 A US 699 1/9/2011 31-12-2019 103 C GB 899 1/10/2011 31-12-2020 102 B IND 1299 1/11/2011 31-12-2021
First we need to sort the above sample data based on product no and price , then we need to create a new file having product field with different prices in single row using C,

Desired output file --

Product price1 price2 price3 price4 101 399 699 999 1099 102 499 699 799 1299 103 599 899

104 1199



Any sort of help would be highly appreciated.