We use an application that generates a financial overview in excel. (Using excel 2010 at the moment.) Because of some configuration in that application sometimes it generates 4 or 5 empty rows between values in excel where we would only want one single empty row. I can't use a macro because those excessive rows do not have the same location every time.
I'm looking to remove those excessive blank rows, but I don't want to remove them all. Single blank rows are fine and very much needed. Is there some formula that would help me remove the extra blank rows minus the one blank row that is supposed to be there?
Hope you guys can help me out.