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