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 | 
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 | 
You can do this with this formula:
=INDEX(FLATTEN(A2:A4&" "&B1:D1))
References:
Generate all possible combinations for Columns(cross join or Cartesian product)
Create a combined list from two separate lists
