Line Break in same cell in multiple columns without affecting other columns

[Pkumar196]

Hello Alteryx Community

Can someone please help me to create a workflow where I can use Line Break option inside a cell on specified columns. I tried using Text to column tool selecting row in option which do separates the words in lines but creates multiple entries. I have attached my sample input and desired output.

Thank you.

[messi007 · Accepted solution]

@Pkumar196,

Please see below :

Attached the workflow,

Regards,

[binuacs]

@Pkumar196 Similar to @messi007  solution with the Multi-Field formula tool

[binuacs]

@Pkumar196 another way of doing this with the Transpoe and Cross Tab tool

[Pkumar196]

Hi @binuacs

Thanks for showing me multiple ways of getting my desired output. The solutions worked for me after making a minor change in the expression. The Expression I used is "Trim(Replace([_CurrentField_], ', ', CharFromInt(10)))".

[Pkumar196]

Hi @messi007 and @binuacs. Thanks for your help and provided solutions. It worked for me.