I have a data in this format Year_Exp Year_Acc Amount 1993 1993 23 1993 1993 34 1993 1994 67 1993 1995 89 1993 1995 45 1993 1996 76 1994 1994 89 1994 1995 34 1994 1995 67 1994 1996 12 1995 1995 90 1995 1996 32 1996 1996 12 could you please help me in getting the output in the below given format using a array in VBA, the idea is get the sum of the amounts for the unique combinations of Year_Exp and Year_Acc. required output 1993 1994 1995 1996 1993 56 67 134 76 1994 89 101 12 1995 90 44 1996 12 Thanks for your help. Regards, Ravi
