how to print 2 SUM 2 rows columns in one row in rtf in Excel

Hi All,

I am working on the rtf template , rdf report is the source.

so i have date, amount, varchar columns.

Date    Invoice#  Amount1     Amount2     Desc

-----   --------  ------   -------     -----

2/15/2017  123   10.23    10.12      INFOSAN S.R.L

2/15/2017  123   1.82      20.12      INFOSAN S.R.L

Expected output

Date    Invoice#  Amount1     Amount2     Desc

-----   --------  -------   -------     -----

2/15/2017  123      12.5    30.24      INFOSAN S.R.L

can you please help me on this?