Clean-Up Excel Merged Cells

[deepakshaw1991]

Hi,

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

Input looks as below:- 

Desired Output:-

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

Thanks in Advance!!

[flying008]

Hi, @deepakshaw1991 

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

[BRRLL99]

can you please attach the file

[deepakshaw1991]

@flying008 Request you to please share the workflow.

[flying008]

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]

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

[deepakshaw1991]

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