excel formula in alteryx (=Cell A1&","& Cell A2)

[gavinloi_]

Hi all, I am trying to figure out this formula in Alteryx. I have a column of data (column A) but I would like the output to be something like column C where the data would constantly be reading from the previous cell. Would anyone have experience in this issue before or if there are any ideas/suggestions. Thank you!

 

[kamal03 · Accepted solution]

Hi @gavinloi_ 

There can be multiple ways to do this but the easiest method is to use a multi-row formula tool.

Try the below workflow and let me know if it worked for you or not.

 

[binu_acs · Accepted solution]

@gavinloi_ 

[malteryx1 · Accepted solution]

You can simply use the multirow formula and convert the datatype to string. PFA

[gavinloi_]

Thank you all!