I have a table as follows:

Account State 1 State 2 State 3 Week
ABC 12 13 141 1
XYZ 13 14 142 2
POP 155 444 1212 2
RSVP 15 28 144 1
XYZ 87 244 680 3
ABC 102 291 787 2
RSVP 117 339 895 2
RSVP 132 386 1003 3

and want to create a summary table as below:

Week 1 Week 2 Week 3
State 1
State 3
State 1+2+3

I am sure this is fairly simpe and wold appreciate any suggestions.

Thanks!!