If my table goes from 1 to 50, and I type in row 51, Excel automatically includes row 51 in my table. And since the table has now automatically expanded, and the pivot table is letting the table ...

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.