Ever wanted to retrieve the formula from another cell as text? No? Hmm…. maybe this only applies to people who are building tutorials for Google Sheets. In any case, it’s a pretty cool method and we can learn a lot about...

If you have a sheet with two columns, you may want to concatenate all values in column B for the same value in column A. SQL equivalent For those familiar with SQL, this is similar to the following ‘group_by’ and ‘group_concat’:...

A common need in Google Sheets is needing to remove extra whitespace characters, such as spaces and tabs, from text fields. Example use cases Spreadsheets often contain data sloppily entered by users who enter random spaces before and after the actual...

There are many situations in which it can be useful to generate all possible combinations for two columns of values. This is done by taking every value in the first column and pairing it with every value in the second column....