The report leaves some cells blank, when report is downloaded to Excel. If cell is blank, the cell should have same value as the cell above. Eg. A5 should be 1, and B5 B, A6 should be 1, and B6 B. In order to have data coherent for Pivot, all the cells in the range A4:B25 should be populated.

You can tackle this issue by VBA or by Excel’s own functionality.

Activate the cells A4:B25 and execute the macro below.

Sub Emptycell()
Dim cell As Range
For Each cell In Selection
If cell= “” then
cell. FormulaR1C1 = “=R[-1]C”
end if
Next cell
End Sub

An other way is to use Go to functionality in Excel.

Activate the cells A4:B25.

In Excel select home and in right corner find & select and Go To. Or press control + G.

Press special -button.

Select blanks and press ok

Write equals shift + 0 and press arrow upwards once. This should be the result.

Press control + enter.

After populating the cells, I normally copy and paste as values, so that the values would not be changed anymore.