Pivot Table Error – This command requires at least two rows of source data
When creating a pivot table in Excel, you might encounter an error that states “This command requires at least two rows of source data”. This error occurs when you don’t have enough data in your source range to create a pivot table.
To fix this error, you need to ensure that your source range contains at least two rows of data. The pivot table requires a minimum of two rows to function properly.
Example:
| Month | Revenue |
|---|---|
| January | 1000 |
| February | 2000 |
| March | 1500 |
In the above example, there are three rows of data in the source range. This is sufficient to create a pivot table. However, if you only had one row of data, the error would occur.
Make sure to check your source range and adjust it to include a minimum of two rows of data. Once you have done so, you should be able to create the pivot table without encountering the error.