Help to split tricky lines into multiple rows (uncatenate on multiple columns)

[Verakso]

Hi Community,

Normally I have no problem fixing data in Alteryx, but today I got some data, that I kind quite can't figure out how to solve

The data looks something like this:

Apparently some data has been concatenated, but not all of them,

I´ve tried the Text to Columns tool. but that only takes one column at the time :(

The "logic" is, that the concatenated fields all have the same position on the row, so the final result would be something like this

Feel a bit like I have made a challenge without knowing the answer.

The tricky part is there, that can be potentially many concatenated fields, and many columns in a mix of concatenated data and not (unique)
But the rule is always, that there is the same amount of concatenations on each row.

Right now I am stuck at this, which besides it doesn't work isn't very dynamic either

/V

[Christina_H · Accepted solution]

Try transposing the data before splitting:

[Verakso]

After I made the post, I did go down that path as well, but not with the greatest success

So brilliant use of the Tile tool, thanks 🙌

/V