T
Thomas Weber
Hi there,
I am trying to do something like the follwing: In Column A I have 7
values from Row 1 to 10, so I have three NULL-Cells. Is there a way to
transform this by formula into a list of values in Column 'B' without
the NULL-Cells, so that only the 'real' values will be left in B1:B7
like shown below?
A B
1 1 1
2 5
3 5 7
4 7 6
5 6 56
6 2
7 56 78
8 2
9
10 78
Appreciate any idea!
Thomas
I am trying to do something like the follwing: In Column A I have 7
values from Row 1 to 10, so I have three NULL-Cells. Is there a way to
transform this by formula into a list of values in Column 'B' without
the NULL-Cells, so that only the 'real' values will be left in B1:B7
like shown below?
A B
1 1 1
2 5
3 5 7
4 7 6
5 6 56
6 2
7 56 78
8 2
9
10 78
Appreciate any idea!
Thomas