Export Data From Power Query into Multiple Excel Sheets based on criteria

Please find here below the structure of the data I am working on, I would like to get some help to find a way that when I export the data from Power Query I am able to achieve 2 things. 1) The data ...