You could copy this to 500 rows or 100 rows or more depending on what your expected pivot table length will be.

Once yourefresh the pivot table with updated contents =IF(P1="","", will ensure that if there are no contents in the pivot table it will return a blank, so you dont need to recreate or retype the formula .

Does that make sense?