Please see attached spreadsheet. This is a receipt I'm trying to extract DATA from, I managed to do so and place the DATA I want to use in columns labeled 1 & 2, the problem is, I want to be able to copy columns labeled 1 & 2 and paste them elsewhere without the "empty rows," is there an easy way to do that? FYI the empty rows contain formulas as you will see!
Bookmarks