Ok. After making 3 QBO support calls (they can't figure it out), and 2 hours of my time. I found a work around. Not perfect but beats manually modifying 10,000 Excel rows.
Good for identifying any mis-categorized transaction from the Profit and Loss Report.
NOTE: only works if you click on the "Total Expenses" line.
Steps:
1) Run the normal Profit and Loss Report
2) Click on the amounts on the "Total Expenses" line item.
3) Click Group By at the top and click "Clear all"
4) Click Save As so it'll be a customized report.
5) Optional. Click "Columns" if you want to hide,show, reorder columns.