Hello all, I’d really appreciate your assistance on how I can perform the following operation:
My data looks like this, a combination of two sets of cell values
|Apple|Red|
|Banana|Green|
|Grape|Purple|
and
|Happy|Smile|1|
|Sad |Frown|2|
|Angry|Pout|3|
My desired output is to have every combination of the sets of each data replicated like such:
|Apple|Red|Happy|Smile|1|
|Apple|Red|Sad |Frown|2|
|Apple|Red|Angry|Pout|3|
|Banana|Green|Happy|Smile|1|
|Banana|Green|Sad |Frown|2|
|Banana|Green|Angry|Pout|3|
|Grape|Purple|Happy|Smile|1|
|Grape|Purple|Sad |Frown|2|
|Grape|Purple|Angry|Pout|3|
So the data replicates and matches based on how many combinations are available. Is this possible to execute? I’d really appreciate the assistance. Thank you!