Offseting data

[Mauricio Samy Silva]

Hi,
Range A1:A100 is filled with data and will count aleatorias empty cells.
Say, there are 27 aleatorias cells empty and 73 with data, in that range.
How to make, to carry the data from A1:A100 to B1:B73 (via formula in this range).
I used =OFFSET formula, with a =LIN() reference in a dummie column,bla..bla..bla, but it's sounds me to be not a clean and good solution. Thanks for comments!

 

[Aladin Akyurek]

Why not stay in your original thread?

That said, try to use Advanced Filter. If you want to do this often, you can create a macro by recording the process of filtering.