Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Appending pairs of columns in Google Sheets

I have a table in google sheets with multiple data like this:

Name 1 Value 1 Name 2 Value 2
John 22 Alex 37
Jack 15 Jake 88

I need a formula to make it that way:

Names Values
John 22
Alex 33
Jack 15
Jake 88

Note that keeping the order is not necessary, I just need all the data in two columns.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

I’ve tried messing with Arrayformula but couldn’t do it.

Any ideas here?

>Solution :

If you have only 4 columns then could try-

={FILTER(A2:B,A2:A<>"");FILTER(C2:D,C2:C<>"")}

If you have more columns then you can add those into curly brackets.

Or using QUERY() function.

=QUERY({A2:B;C2:D},"where Col1 is not null")

enter image description here

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading