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’:...

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....