Hide blank rows in column -> in another column

Are there any columns apart from A that always have data in them? If so you could try something like this. I should point out with 1000 rows it won't be instant.

Please Login or Register  to view this content.

Here's a formula method.

Data Range

	A	B
1
2
3
4	Data1	Data1
5		Data2
6	Data2	Data3
7	Data3	Data4
8	Data4	Data5
9		Data6
10	Data5
11
12	Data6
13

This array formula** entered in B4:

=IFERROR(INDEX(A:A,SMALL(IF(A$4:A$12<>"",ROW(A$4:A$12)),ROWS(B$4:B4))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.