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?
Bookmarks