Is it possible to have a formula in Google sheet to place the 1st text of the 2nd column next to 1st text of the first column, and the 2nd text of the 2nd column next to 2nd text of the first column
LIke :>
| A header | Another header |
|---|---|
| row1a row1b | text1a text1b |
| row2a row2b | text2a text2b |
into this:
| A header |
|---|
| row1a text1a row1b text1b |
| row2a text2a row2b text2b |
CodePudding user response：
try:
=ARRAYFORMULA(TRIM(FLATTEN(QUERY(TRANSPOSE(QUERY(SPLIT(FLATTEN(QUERY(
TRANSPOSE(A2:B),,9^9)), " "), "select Col1,Col3,Col2,Col4", )),,9^9))))
