Add Values to one field based on the existing field

[swapsingh2712]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @swapsingh2712 

One way of doing this

[Qiu]

@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?

[flying008]

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.

[grazitti_sapna]

@swapsingh2712  Other way of doing it with Transpose tool and filter.

[swapsingh2712]

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

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Add-Rows-based-on-other-columns/m-p/10...