Once you have added your column, put the following formula in cell A3:

=IF(LEFT(B3,8)="Customer",B3,A2)

And copy down.

Then copy all of column A and Paste Special | Values.

You can then filter on column B to select the Customer headers and delete the rows.

For a macro, record these steps as you do them manually.


Regards, TMS