I'm trying to transfer items in a column from one google sheet to a column in another google sheet ignoring blank cells entirely.
I have this formula that will transfer all cells including the blanks:
=ARRAYFORMULA(FormResponses1!C:C)
I also have this formula that does the same substituting the blanks with the word "hello":
=ARRAYFORMULA(IF(FormResponses1!A:A="","",IF(ISBLANK(FormResponses1!C:C),"hello",FormResponses1!C:C)))
I'm trying to transfer the non-blank cells to the other sheet ignoring the blank cells altogether, making a column with 5 cells as opposed to 7 cells as below The column being transferred from the original sheet looks like this:
- Apple
- Peach
- (Blank cell)
- Orange
- (Blank cell)
- Grape
- Cherry
I need the new sheet to look like this without any blank cells in the column:
- Apple
- Peach
- Orange
- Grape
- Cherry
I can't seem to find a way to do it. Any help would be greatly appreciated!
Thanks, Neal