Quickbooks Desktop Excel Report formatting


I’m curious if anyone has any recommendations for formatting standard P&L reports from QB Desktop so that they can be brought into Power BI for analysis. The current structure of these reports unstructured to properly pull into PBI. Here is a typical example: