Hi and welcome to the forum

Try tis, using a helper in "data" ( I used C, you can use whatever you want, you can also hide it). Copy this to C2, and then copy down...
=IF(B2=0,C1,C1+1)
Then in "report", use this in A5, copied down and across...
=IFERROR(INDEX(data!$A$1:$B$6,MATCH(ROW($A1),data!$C$1:$C$6,0),MATCH(report!A$4,data!$A$1:$B$1,0)),"")