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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results