Hello All,
I've a data set which looks kinda below
Issue_1 | Issue_2 | Issue_3 | Issue_4 |
aaa | ggg | iii | |
bbb | eee | mmm | |
ccc | fff | ||
ddd | hhhh | kkk |
Now I want combine these values under one column only and then remove other columns. So my final data should look like below
Issue_1 |
aaa |
bbb |
ccc |
ddd |
eee |
fff |
ggg |
iii |
mmm |
kkk |
Could you please advise how this can be achieved in alteryx?
BR
swap
Solved! Go to Solution.
@swapsingh2712
Can I confirm why the "hhhh" value is removed in your sample output?
And what happens if there are duplicated values in the input?
Hi, @swapsingh2712
There is a easy way for you:
******
If it can help you get your want, please mark it as s solution and like for more share.
Hello All,
Thank you so much for your help. I've posted a another questions similar to this one. If you could help. I forgot to add one condition in this scenario