2d range

  1. D

    Consolidating non-blank rows from a 2d range

    I have a 2d range which has some blank rows in it. I would like to be able to take the non-blank rows and consolidate them as a contiguous block in another range without disturbing the original table. Any ideas, anyone?

Some videos you may like

This Week's Hot Topics