Data Cleanse Merged Cells

Hi,

I have a horribly set up data table in Sheet1 of the attached workbook and was wondering if I could convert what it is in Sheet1 to what it looks like in Sheet2.

Is there any way to easily do this in Alteryx?

Thanks,

sample file.xlsx

Transformation

Accepted answers

Here's a quick and dirty way

data cleanse.png

data cleanse.yxmd

This is a better solution for many columns.

data cleanse.png

data cleanse 2.yxmd

All comments

Here's a quick and dirty way

data cleanse.png

data cleanse.yxmd

It assumes your first row is populated

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703