1

I have 2 tables (matrixes) for instance

a
b
c

and

x
y
z

I would like to the final result to be

a x
a y
a z
b x
b y
b z
c x
c y
c z

How can it be possible

Daniel Santos
  • 14,328
  • 21
  • 91
  • 174
  • a, b, c and x, y, z are text or numeric? – Mike Steelson Nov 22 '21 at 16:07
  • It is unclear whether final results should be joined in one cell for each row, or split across two columns per row with one in each column. In the interest of efficiency, it would also help if you gave the actual ranges where the original `a b c` and `x y z` reside in your sheet. – Erik Tyler Nov 22 '21 at 16:22
  • https://stackoverflow.com/a/68775825/5632629 – player0 Nov 22 '21 at 21:47

1 Answers1

1

Desired output is unclear whether it is in a single or separate columns, so I'll provide both outcomes:

Single column (C1):

=INDEX(FLATTEN(FILTER(A:A, A:A<>"")&" "&TRANSPOSE(FILTER(B:B, B:B<>""))))

Separate columns (D1):

=INDEX(SPLIT(FLATTEN(FILTER(A:A, A:A<>"")&" "&TRANSPOSE(FILTER(B:B, B:B<>""))), " "))

Output:

output

NightEye
  • 10,634
  • 2
  • 5
  • 24