Index return row to column without duplication

Good Morning Sir,

I need your help.

Index return respective values row and column wise without duplication.

file attached.Please help me.

RAW DATA;

CODE---BIIL NO---VALUE---DATE
302356---0239---245980---41779
300004---0602---61375----41779
300028---4-15---256977---41779
302075---0289---3043-----41779
302075---0288---11497----41779
300001---1828---72303----41779
300001---1492---9082-----41779
300001---1423---70756----41779
302289---0789---245980---41790
300001---1963---66796----41790
300001---2169---35593----41790
300001---2270---24100----41790
300001---2326---28325----41790
300001---2502---51738----41790
300001---2699---21423----41790
300001---2663---26778----41790
300001---2963---2475-----41790
300004---0749---30805----41790
300004---0752---24840----41790
300004---0667---15688----41790
300004---0645---1480-----41790
300004---0813---5652-----41790
300028---4-15---368317---41790


REQUIRED FORMAT;

DATE ---------TOTAL BILL--- CODE ---------NO OF BILL--- SUM OF VALUE

20/05/2014--- -----8 ------300001------ ------3----- ------152142
-----------------300004------------1------ -----61375
-----------------300028------------1------ -----256977
-----------------302075------------2------------14540
------------------302356-----------1------- -----245980
31/05/2014-------15--------300001-----------8-------------257232
------------------300004-----------5-------------78466.78
------------------300028-----------1-------------368317
------------------302289-----------1-------------245980

please help me someone.if possible.

Mr.Sktneer sir.

thanks you so much for your help.doesn't possible for apply any formulas.

shukla.ankur281190.

Thank you so much for your help and advice. i have followup your suggestion.To learn something new for your formulas.