I want to combine two lists in Google Spreadsheet so that the cells interleave.
Both lists have the same amount of elements.
So that:
1 A
2 B
3 C
becomes:
1
A
2
B
3
C
The closest I came up with is something like JOIN({List A},{List B})
, but in this way the Elements of List B
are only split by the first Element of List A
.
It would be great if someone has an idea without any add-ons using only the built-in functions. Transposing and formatting is not that important.