Unmerge Excel Rows and duplicate data

[Gowtham_Subra]

Hi Everyone,

I'm looking for help in creating a workflow to unmerge rows in excel data and replace nulls with appropriate data using Alteryx. The merged cells are not consistent and it reads as null values when I import it into Alteryx.   Thanks very much in advance for the help.

Thanks

Gowtham

 

[alexnajm]

Multi Row Formula tools will be your friends here! Use it to fill down the values: Solved: How to fill down in alteryx - Alteryx Community

[Gowtham_Subra]

Thanks for the quick reply, Alex. Is there a way to do all columns at once? I'm dealing with more than 50 fields and different inputs have different fields merged.

[alexnajm · Accepted solution]

There's a Community macro that may work - I haven't used it but I know it's popular: Multi-Row -Field -Column Macro example - Alteryx Community

[Qiu · Accepted solution]

@Gowtham_Subra 

I have tried the macro and also use the "Conventional" way and I am convinced the macro is more efficient.

@alexnajm 
Thank you for the introducing this macro.

[alexnajm]

Happy to do so @Qiu!

@Gowtham_Subra if it works for you, please mark one or more of our responses as a solution. Thanks in advance!