In a previous post I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from the data capture. But how do...
Tag: Google Sheets
Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real...
How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets...
The only limitation with the ARRAY_CONSTRAIN function is it fetches from the upper-leftmost corner of the range. Here we combine the QUERY and TRANSPOSE functions to flip a range, so the...
When using the QUERY function in Google Sheets how can we ignore certain rows based on the criteria of some cells being blank?
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...