Get values from blank cells

[canvas]

Hi,

I have some width and height values in several columns with a lot of
blank cells of sheet2. Like this:

A B C
blank blank 2*987
blank blank blank
blank 4*500 blank
5*400 blank blank

How can I get only the cells with values in column A of sheet1:

A
5*400
4*500
2*987

Can this be done!

Thank you so much

 

[Brad]

What do you want to do if there are two values in a row? Average them? Add
them? Both of these would work as long as if the values were numbers or
blank.

 

[canvas]

Hi,

I don´t wanna do either of them, just write them down in column A
because they are meassure notes. For example:

Sheet 2

A B
2*345 4*124
blank blank
6*50 blank

The should go in Sheet 1:

A

2*345
6*50
4*124

Thank you very much for your time