I want to be able to fill in the blanks on a Pivot table without using copy and paste but using the previous data above to fill the blanks below each data. Please what formula can I use? Thanks