Skip to content

> script everything

  • Send Ryan A Message

Tag: SPLIT

4 Simple Steps to Merge 2 Columns Into 1 With QUERY Function

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.

Published May 20, 2020
Categorized as Cloud Apps Tagged ARRAYFORMULA, Google Sheets, JOIN, QUERY, SPLIT

Easily Merge Multiple Columns Into 1 with Query & ArrayFormula

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.

Published May 19, 2020
Categorized as Cloud Apps Tagged ARRAYFORMULA, Google Sheets, JOIN, QUERY, SPLIT, TEXTJOIN, TRANSPOSE

Recent Posts

  • Multiple WordPress Installs On One Lightsail Bitnami WordPress Box
  • DATEDIF How to Calculate Difference Between 2 Dates
  • 3 Simple Steps To Send Email With Amazon SES
  • Receive Custom Domain Email Using Amazon SES, Lambda & S3
  • Why Go Static?

Categories

  • Cloud Apps (50)
  • Coding (24)
  • Software (14)
> script everything
Proudly powered by WordPress.