Hi,
I have a report I get from a program. When i export this report into excel, it merges the cells and leaves empty rows. I can copy and paste special as text into another spreadsheet, that basically un-merges the cells however, leaves empty columns and rows. I need a code/macro to delete these blank rows and columns and give me a clean file that I can pivot. Please help.