REMOVING EMPTY ROWS IN A REPORT

Replace the row with previous level
      Ex: iif(level2="",level1,level2)
             level3="",Product_name,level3
         
Row visibility

   level3=productname
   level4 is nothing
   level3=productname for product name