Excel document cleaning through Alteryx

Question

Hi everyone, hope you are well!

Need some help trying to clean up some data. As you can see, the data as separated and will need them to move back to their rows (Refer to "WHAT IS LOOKS LIKEE). Basically I want to shift some data either 2 or 1 column to the left. I want it to look like the doc 'What I want it to look like'. Please help

Sivory18 · Answer

Hi @binu_acs, I appreciate your help. I used the same method you showed me for the full data set, but it didn’t work correctly for some rows. I’ve uploaded the complete data (please refer to the 'Data' file). Could you please help me with this?

Data.xlsx

binu_acs · Answer

@Sivory18 one way of doing this

Transform_22022026.yxmd

BS_THE_ANALYST · Answer

@Sivory18, what's the general logic applied here?

For instance, for any given row, if there are nulls in a column, look at columns to the right and shift every column's values leftwards? Essentially, keep pulling values leftwards, along the row, until they're all touching (no nulls between) and as far to the left as possible?

Is this just for a subset of the columns available? Is this logic reproducible or just a one-off solution? Why has this happened i.e (cell merging)?

You'll reach a robust solution faster if you provide these types of details