Skip to content

Instantly share code, notes, and snippets.

@Max-Makhrov

Max-Makhrov/Cross-join-Google-Sheets.sheets

Last active December 22, 2017 09:04
Show Gist options
  • Save Max-Makhrov/52d54bac33c7fa1d43ea900ffef2f198 to your computer and use it in GitHub Desktop.
Save Max-Makhrov/52d54bac33c7fa1d43ea900ffef2f198 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Cross-join-Google-Sheets.sheets
=ArrayFormula(
transpose(split(rept(concatenate(A2:A&char(9)),counta(B2:B)),char(9)))
&" "&
transpose(split(concatenate(rept(B2:B&char(9),counta(A2:A))),char(9)))
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment