I am having trouble moving data from one column (I am using this column as a helper column for data based on another sheet) into a different column on the same sheet, but without bringing along blank cells.
This is the situation:
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
What I've been trying to get:
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
I need each different category (name, address, etc) to be in their own cell. Is there a way to do this without messing with the helper column's (column B's) function? The function is an IF function.
I have tried different array functions with no success.
This is the situation:
A | B |
First Name | |
Last Name | |
Address |
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
What I've been trying to get:
A | B |
First Name | |
Last Name | |
Address |
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
I need each different category (name, address, etc) to be in their own cell. Is there a way to do this without messing with the helper column's (column B's) function? The function is an IF function.
I have tried different array functions with no success.