Forum Discussion
marami21
6 years agoFrequent Visitor
Stack columns one after the other
I have something like this: And I need to change it to something like this. I know this can be done with unpivoting but I've tried several times and I have not been a...
- 6 years ago
Hi marami21
Please see the attached solution, its three steps using UI only.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
marami21
6 years agoFrequent Visitor
Can you please explain to me what does split column by character transition do?
Mariusz
6 years agoCommunity Champion
Hi marami21
If you asking how it works, its a function that iterates each "Attrbute" field, converts it into a list, scans this list for numbers 0 to 9 and splits the column if the number is found.
The below screenshot shows how to create this step.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.

Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.