How to merge two or more cells in to one row using ssis package

See more:

SSIS

Hi Every one,

i am new to ssis package.am reading data from excel file and storing in to the database. After that the same data writing in to the excel like the below format.

Input:-

Sno Sname Amount
1    Sam    2500
2    ram    3500

output:-

Sno Sname Amount
1    Sam    2500
2    ram    3500

my requirement is if excel file has duplicate sno like the below format.

Input:-

Sno Sname Amount
 1   Sam    2500
     kumar  450
     james  350
----------------
2    ram    3500

I need to display the excel in the below format.

Sno  Sname  amount
      Sam    2500
  1   kumar  450
      james  350
------------------
  2    ram    3500

means i have to merge the three rows into one row.

kindly anyone help me how to do this..