What is required of source data for a PivotTable to work correctly?
- A Flat data with one header row, no blank rows and no merged cells
- B Data sorted alphabetically
- C At least 1,000 rows
- D Data on a separate workbook
Answer
Flat data with one header row, no blank rows and no merged cells
Cross-tabulated data with months as separate columns must be unpivoted first, which Power Query does easily.





