Combine and Sort two tables

A number of you have been kind enough to help me develop this chart to combine and sort tables. I originally thought I wanted the zero values to show, but am unable to chart the data accurately with the zeros. I there a way to obtain the "desired Result"?

Using your file modify as follows:

Please Login or Register  to view this content.

G & L are minor alterations re: what to populate with should the MPH be blank ... M is a fairly significant change from before (in terms of populating the appropriate RPM)