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 |