Hot answers tagged formulas
Although this is a special case of In a Google Spreadsheet, show all combinations for a selection of columns I think it's good to have a simpler answer specifically for the case of two columns. The technical term is "Cartesian product of two sets". I use the same method as Rubén, which requires a character that does not appear in the column entries. Rubén ...
Only top voted, non community-wiki answers of a minimum length are eligible