Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. =transpose(split(join("", arrayformula(rept(filter(A1:A, len(A1:A))&char(9999), counta(B1:B)))), char(9999)))
  2.  
  3. =transpose(split(rept(join(char(9999), filter(B1:B, len(B1:B)))&char(9999), counta(A1:A)), char(9999)))
  4.  
  5. a b c 1 2
  6.  
  7. a 1
  8. a 2
  9. a 3
  10. b 1
  11. b 2
  12. b 3
  13.  
  14. function crossJoin(arr1, arr2, delim) {
  15.  
  16. delim = delim || '';
  17.  
  18. var result = [];
  19. var row = [];
  20. for (var i = 0; i < arr1.length; i++) {
  21. for (var j = 0; j < arr2.length; j++) {
  22. row = [];
  23. row.push('' + arr1[0,i] + delim + arr2[0,j]);
  24. result.push(row);
  25. }
  26. }
  27. return result;
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement