I tried advanced filter and I can't delete blank cells as they have formulas..
I want to maintain the structure of my table so I don't want to sort it
can you provide me with a macro that extract the values without blanks to another column?