I wish to merge data in column B by comparing them with value in column A. Also sum of column C also to be calculated by comparing with column A. Sample data is attached herewith.
EST DATE AMOUNT
MDMDU0000158000 01-Apr-16 75
MDMDU0000197000 01-Jan-17 75
MDMDU0000197000 01-Feb-17 75
MDMDU0000197000 01-Dec-16 75
MDMDU0000197000 01-Mar-17 75
MDMDU0000689000 01-Apr-16 368
MDMDU0000689000 01-Jan-16 368
MDMDU0000689000 01-Jul-16 368
MDMDU0000689000 01-Jun-16 368
MDMDU0000689000 01-May-16 368
MDMDU0000689000 01-May-15 368
MDMDU0000689000 01-Sep-15 368
MDMDU0000689000 01-Feb-16 368
MDMDU0000689000 01-Mar-16 368
MDMDU0000689000 01-Jun-15 368
MDMDU0000689000 01-Jul-15 368
MDMDU0000689000 01-Oct-15 368
MDMDU0000689000 01-Nov-15 368
MDMDU0000689000 01-Dec-15 368
MDMDU0000689000 01-Feb-15 368
MDMDU0000689000 01-Mar-15 368
MDMDU0000689000 01-Aug-15 368
MDMDU0000689000 01-Apr-15 368
Bookmarks