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
