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

Thanks Marvin. This problem is "making me VERY ANGRY", to quote the other Marvin... Your solution is close to what I'm looking for but there are a few distinctions.... Please see my updated attachment. I need to have the Machines grouped and a row for each "Element" with the four columns (Input, Converted, Duty Factor and Average) in the same order as listed in the raw data. I am trying to write a script that would operate in these steps:
1. For every Machine row the Element range cells are scanned to determine how many Element cells (clustered in 4 columns) are populated in each row. The sum of these populated cells (for one row) is divided by four to determine how many rows need to be inserted beneath each Machine listing. Since the first row can already contain one group of these 4 elements, one row would be subtracted from the total. So, in the example attached all three Airplane Elements groups are populated so 3-1 = 2 rows inserted under the first.
2. The Machine title (only) auto-populates in each of these rows (Column A).
3. The first group of (4) Elements are entered into a set of four columns in this first row. The Units (shaded in yellow) are entered as well in their own column.
4. The second group of (4) Elements are entered into the second row, the third group to the 3rd row, etc., until it reaches the end of the Elements (last columns) found in the original row.
5. This process repeats (loops) for the next Machine listed until all of the Machines have the correct number of rows added and Elements listed.

If you have time to give this a shot I'd really appreciate it. Or if you can send me some advice as to how you would go about writing the script I will take my best shot. Either would be great. Thanks Marvin. David