You may be good at Excel, but you’re spending way too much time clicking around.
Avoid PivotTable failures caused by merged cells, blank columns, and subtotals, with Power Query steps to clean the source ...