JOIN result exceeds 50,000 character limit

Question

I am trying to combine text from column A and match it with each BI column capability using formulas:

in C1:

=transpose(split(join("", arrayformula(rept(filter(A1:A, len(A1:A))&char(9999), counta(B1:B)))), char(9999)))  

in D1:

=transpose(split(rept(join(char(9999), filter(B1:B, len(B1:B)))&char(9999), counta(A1:A)), char(9999)))

but when I use it on my list, I get these errors in C1 and D1 respectively;

JOIN text result longer than 50,000 character limit.
REPT text result longer than 32,000 character limit.

I checked this with a smaller list simply:

a b c 1 2 

and managed to get my list to generate this after merging the two cells:

a 1
a 2
a 3
b 1
b 2
b 3

but the list that I am combining contains much more text in each of the columns.

Any suggestions on how to merge my lists as shown above, but with 132 capabilities in column A and 52 capabilities in column B?

70 150 .

Answer 1

Tools → Script Editor...

:

function crossJoin(arr1, arr2, delim) {

  delim = delim || '';

  var result = [];
  var row = [];
  for (var i = 0; i < arr1.length; i++) {
    for (var j = 0; j < arr2.length; j++) {
      row = [];
      row.push('' + arr1[0,i] + delim + arr2[0,j]);
      result.push(row);
    }   
  }
  return result;
}

.

:

=crossJoin(A1:A132,B1:B52)

:

=crossJoin(A1:A132,B1:B52, "-")

Answer 2

: "" . ( 7, "")

. ?