Data Transformation, splitting a flat sharepoint for an inventory list

Hi,

I have a dashboard working from two Excel tables (TABLE 1 and TABLE2 below) connected by a many-to-many relationship between the "Site" name I want to make this "live" and easier to use. So created a powerapp to collect all the required data. This is a dataverse table which has a "flat" output below into a directquery for PowerBI. (structure represented below)

Is it possible to transform the directquery dataverse into two tables like above using powerquery? Or do I need to have my powerapp create two tables?

Thanks for any help.