Data lists and ignoring blank entries

[Dale Walker]

Just getting back into working with excel and I need to do the following
(with functions - not into VBA yet): List A is entered on sheet 1 - a
summary List B is on sheet2. I want to ignore any blank rows on list A in
List B.

1 Becomes 1
2 2
4
4 5
5

Thanks
Dale Walker

 

[Patti]

Not sure if this is the best way, but one way is:

Hi-light the range
Edit - Go To - Click Specials
Click Constant
Click OK
CTRL C
Go to the cell where you want the data
CTRL V