I have a spreadsheet that is generated by vbscript that the first column looks like the text below.

Mechanics
Maint Supplies & Equip
Maint Supplies & Equip
Repairs to Paving
Repairs to Paving
Repairs to Roof
Repairs to Roof
Repairs to HVAC
Repairs to HVAC
Repairs to HVAC

I would like to have it look like:

Mechanics
Maint Supplies & Equip

Repairs to Paving

Repairs to Roof

Repairs to HVAC

Putting blank cells in the place of the duplicated cells. I figured out how to delete the dups but that will not work for my purpose.....Any ideas?