From this table...

enter image description here

...the following formula in Excel...

=choose({1, 2}, E18:E23&" | "&F18:F23, G18:G23)

enter image description here

...gives me this

 {“UK | Primary”,555;”France | Primary”, 543;……}

enter image description here

However, in Google Sheets, it just gives me the first column. {1, 2} doesn't seem to work? How do I select two columns? The documentation for this function doesn't tell me


=ARRAYFORMULA({E18:E23&" | "&F18:F23, G18:G23})


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.