Hi,

In the attached workbook I sort data so totals can be calculated by order number and product. However, the way I have done this creates blank cells. Is there anyway to remove blanks but not delete the row? When I sort the data it just gets rid of the line so the invoice layout then changes to a tiny sheet.

invoice partial.xlsx