Removing empty rows from a range without changing worksheet layout

Hi everyone,

I have a range within a complex worksheet, which displays rows of data spanning 7 columns ('C' to 'I') and 17 rows ('6' to '22').

This range is surrounded by other cells containing data which is irrelevant to the question, aside from the fact that its location and structure needs to be maintained.

In any given row, cells 'C' to 'H' will either all contain data or all be blank.

Cell 'I' would never contain data if 'C' to 'H' are blank, but cell 'I' may or may not contain data if cells 'C' to 'H' are populated.

As an example, let's say I have data in rows 6, 7, 8, 10 and 12. I need to find a way to remove rows 9 and 11 so that the populated rows are consecutive without any blank rows in between. I also need to maintain the structure of rows 23 and above, AND I cannot delete anything in columns 'J' and above so the solution must not delete entire rows from the worksheet.

An example is attached. This has been frustrating me for hours!! Any input would be massively appreciated.

Regards

Andy