Rami Alshoubaki
Rami Alshoubaki

Reputation: 67

Combine column cell interchangeably in one column

Let us assume we have the following tow columns :

column 1

1
3
5

column 2

2
4
6

the result column

1
2
3
4
5
6

and in case the two columns are not equal in size, the combined result should be without empty cells at the end!

Upvotes: 1

Views: 108

Answers (1)

player0
player0

Reputation: 1

=FLATTEN(A1:B)

0


=TRANSPOSE(SPLIT(TEXTJOIN("♦", 1, A1:B), "♦"))

enter image description here


=INDEX(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(TRANSPOSE(
 IF(A1:B="",,"♦"&A1:B)),,99^99)),,99^99), "♦")))

0

Upvotes: 4

Related Questions