I am trying to use the
JOIN functions in Google Sheets (the new version) to manipulate some data, and I am running into problems because
SPLIT is not preserving blank entries.
The data source is set up like this, essentially:
| A B C D ----------------------- 1 | q 5 r 2 2 | s t 4 3 | u 8 v 4 | w 3 x 6
(The blank entries in this data set represent "no measurement", which is distinct from a measurement of
C, I'm getting the result I want by using the formula:
That produces a row that goes, as expected,
x, each in its own cell.
However, this method doesn't work on columns
JOIN functions as expected, giving the output:
SPLIT on that output, however, results in a problem: I'm left with
6, without empty cells between
8 or between
6, which means the pairs are broken up (e.g.
v should correspond to empty cells, but instead
x do). The problem seems to be that
SPLIT is interpreting
~~ as a single delimiter, rather than as two delimiters with a null entry between them.
Does anyone know how to preserve blank entries in this sort of scenario?
The desired output would look like this
q s u w r t v x 5 8 3 2 4 6