Grouping of data and paste same value for that group in excel

[Sunita_Pandharmise]

Hi,

I have merged excel based on column name.
Now, for one column name as “FYC” I want to put total on that rows which can get adding “FYC Amount” column and with respect to that I want to put currency code next to it.

Please find input screenshot

Please find output screenshot

Can someone please help

[Manjuts90]

@Sunita_Pandharmise can u share sample excel file