Parse data table

I need to parse a large table of equipment and its various utilities consumed. Please see attached simplified file. I need help understanding how to add extra rows required, and how to loop through the utilities to only add those that are populated, ignoring those that aren't. I appreciate any advice. Thanks. David