split multiple columns with the concatenated values into rows in alteryx

Question

Hi all,

The dataset has 9 columns, but the values ​​in each column are separated by a comma (,). How can I select all the columns at once and extract the concatenated values ​​to split them into rows in Alteryx without using Text to columns tool multiple times?

Can we use muti field formula tool and acheive the desired result? Please advice.

Thanks & regards,

stj.

Book1.xlsx

New Workflow5.yxmd

dreldrel · Answer

You could consider text to column tool. This can help you to split the cells to either rows or columns

lwolfie · Answer

Not sure if you figured this out, but here's an option to split them out without multiple text to columns.

New Workflow5.yxmd

flying008 · Answer

Hi, @stj1120

Could you please upload data table as your want output ?