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
