Hi Alteryx Community,
I have a dataset where I have merged data in the first two columns.
Is there an easy way to split data so I have it on each row?
Best regards,
Pascal
Solved! Go to Solution.
Hi @Pascal_R
Can you provide some sample expected output It will help us get a better understanding of the usecase.
We will be happy to help : )
HI @atcodedog05
See below, left the raw data I have and the right side is what I try to get with Alteryx.
Hi @Pascal_R ,
I think, Multi-Row Formula tools should solve your problem:
Each cell in the first two columns is checked, if it is empty, and if so, the value from the last cell above is used.
Let me know if it works for you.
Best,
Roland
Hi @Pascal_R
You would need to use multi-row formula tool to fill down the blank data for both columns like below.
Edit: Similar as @RolandSchubert
Hope this helps : )
Happy to help : ) @Pascal_R
Cheers and have a nice day!
Thank you both! I can see now the issue in my formula :)
I think maybe we can do this a more dynamic way, in case you have more columns mreged.
And there is null cells in your material columns.