We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Clean-Up Excel Merged Cells

deepakshaw1991
7 - Meteor

Hi,

 

I need a help to clean-up an excel table with the help of alteryx.

 

Input looks as below:- 

deepakshaw1991_0-1660938542157.png

 

Desired Output:-

deepakshaw1991_1-1660938570626.png

 

I need to solve this urgently. However, I am not authorised to upload excel. Please help me to solve this.

 

Thanks in Advance!!

6 REPLIES 6
flying008
15 - Aurora

Hi, @deepakshaw1991 

 

Maybe you need use Multi-Row formula + Text to Columns repeat again.

 

录制_2022_08_20_12_06_44_851.gif

BRRLL99
11 - Bolide

can you please attach the file

deepakshaw1991
7 - Meteor

@flying008 Request you to please share the workflow.

flying008
15 - Aurora

Hi,@deepakshaw1991  @BRRLL99 

 

Due to the restrictions of the security policy, I cannot upload my workflow file, but I have clearly marked the purpose of the process in the animation gif, please create it according to the process by yourself, sorry!

deepakshaw1991
7 - Meteor

@flying008 I am unable to understand the formula used in multi-field formula. Can you share the formula.

deepakshaw1991
7 - Meteor

@flying008 Please share the codes used. I am unable to understand, but this is what I need. Please help

Labels
Top Solution Authors