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

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.

Input Output.xlsx

Workflow

Accepted answers

messi007

@Pkumar196,

Please see below :

Attached the workflow,

Regards,

LineBreak.yxmd

All comments

messi007

@Pkumar196,

Please see below :

Attached the workflow,

Regards,

LineBreak.yxmd

binu_acs

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

Split_Into_16_05.yxmd

binu_acs

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

Split_Into_16_05.yxmd

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.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703