SQL Logic to add Account

Hi Expert

please suggest SQL Logic to Add this same account for different time period for same Year

CATEGORY RPTCURRENCY YEAR ACCOUNTFBENTITYCOSTCENTER FBTIME SIGNEDDATA

MAYF GBP 2010 ACCPYCALC CEGB11SED20950 2010.APR 150

MAYF GBP 2010 ACCPYCALC CEGB11SED20950 2010.MAY 250

MAYF GBP 2010 ACCPYCALC CEGB11SED20950 2010.FEB -500

Regards

Gayu