Custom M Script to sum values from Joined/Merged Queries

Hi guys heres what i'm trying to accomplish....   My data structure Table1:  ID#| Capability.1 | Capability.2 | Capability.3| .... 37 total Capability.# columns 97 | Crawl | Walk |...