0

If I have a google sheet with the following rows and columns

Red Green Yellow
Apple
Grape
Pear

Is there a formula to create the following list.

Apple Red
Apple Green
Apple Yellow
Grape Red
Grape Green
Grape Yellow
Pear Red
Pear Green
Pear Yellow
Warcupine
  • 4,460
  • 3
  • 15
  • 24
Keith
  • 1

1 Answers1

0

You can do this with this formula:

=INDEX(FLATTEN(A2:A4&" "&B1:D1))

ex

References:
Generate all possible combinations for Columns(cross join or Cartesian product)
Create a combined list from two separate lists

kaitlynmm569
  • 1,605
  • 1
  • 6
  • 18