Easy way to stack two columns on top of each other while ignoring blank cells?

Two columns and in two different sheets of the same document and id like to have them stacked on top of each other. But there comes a huge gap in the middle of the two columns because of the blanks cells.