Hi all,
Spreadsheet only please --
I have 1 column of data but some columns are blank… actually the formula each of the cells of this column is =if(CONDITION, DO_THIS, "").
I need to create another column where only the non-blank cells are there.
Thanks.
Simple Example --
Column A
1
2
3
562
46
97
Column B
=if(A1>32, do something to B1, "")
=if(A2>32, do something to B2, "")
..
..
Column C
Will have only the non-"" cells from Column B one after the other .. i.e. no empty looking cells here.
Spreadsheet only please --
I have 1 column of data but some columns are blank… actually the formula each of the cells of this column is =if(CONDITION, DO_THIS, "").
I need to create another column where only the non-blank cells are there.
Thanks.
Simple Example --
Column A
1
2
3
562
46
97
Column B
=if(A1>32, do something to B1, "")
=if(A2>32, do something to B2, "")
..
..
Column C
Will have only the non-"" cells from Column B one after the other .. i.e. no empty looking cells here.