Is there a script that will compare values within a table and summarize them into another table?

[Gene-O_1990]

Hello!

I have created Table1 with two columns: Day and Hours. The user will enter the day of the week they worked, and the number of hours they worked on that day of the week (in no particular order). I need a script that will run Table1 and summarize the entries for me into Table 2.

TABLE 1

Day                                   Hours

Sunday                            8

Wednesday                     4

Thursday                         16

Sunday                            2

Thursday                         10

TABLE 2 (results)

Sunday                              10

Wednesday                       4

Thursday                          26

any ideas?

I'm using Livecyle Designer ES2 v9

Thanks so much!!

Gene-O