SOLVED

Generate a colum by combining two other columns

New Contributor

Hello,

 

I want to know if there is a way for me to combine two columns in a way that each cell on the first row is concatenated with each item of the second column.

 

For example in the below case, I would like to generate column C to be A1,A2,A3,B1,B2,B3,C1,C2,C3 

arajagopal4_0-1670431230384.png

 

Is there anyway I can do this?

 

2 Replies
best response confirmed by arajagopal4 (New Contributor)
Thanks Hans. This is exactly what I was looking for