JOIN

How do you merge multiple columns into one column in Google Sheets using the QUERY function? In this 4 simple step-by-step process we share the formula, and teach you along the way on how component within the function works by providing commentary and photos at each change.

Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.