Max Date using Filename

[#1]

Hi,

Please help me with the following task:

Ii have Data as :

Name 1 2 3 4 5 6 7 8 9

A 10 20 30 100 121 131 200 300 400

B 11 21 31 101 122 132 201 301 401

C 12 22 32 102 123 133 202 302 402

D 13 23 33 103 124 134 203 303 403

F 14 24 34 104 125 135 204 304 404

Note: Day pick from top header

  Month&year pick from filename

And my Requirement is :

Date Name Value

Max date A sum(Values)

Max date B sum(Values)

Max date C sum(Values)

Max date D sum(Values)

Max date F sum(Values)

For example:

Date	Name	Value
9-Mar-2014	A	400
9-Mar-2014	B	401
9-Mar-2014	C	402
9-Mar-2014	D	403
9-Mar-2014	F	404

Thanks

Ankit