Unmerge Excel Rows and duplicate data

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.

Alteryx Test.PNG

Test Image.PNG

Thanks

Gowtham

TEST.xlsx

Preparation

Accepted answers

alexnajm

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

@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.

0107-Gowtham_Subra.yxzp

All comments

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

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

@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.

0107-Gowtham_Subra.yxzp

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703