Moving data to left most empty cell

[Automatingtaxes]

Hi everyone,

I'm struggling to move data over to the left most empty cell in a row.

I'm converting a PDF in adobe to an excel spreadsheet and then running it through alteryx. The problem is the PDF is converted with many cells being merged. When it enters alteryx its no longer merged and there are many columns. I just want to move all the data in a row to be next to each other. I need the data to be moved to the farthest left empty cell. So if there's 100 columns and only 15 of them have data for row 1, I want those 15 columns of data next to each other and for it to do this for each row.

Any thoughts?

I appreciate your help.

[ArtApa]

Hi @Automatingtaxes - Here is a possible solution for you:

Data sample:

Result: