Add Values to one field based on the existing field

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

Transformation

Help

Accepted answers

Hi @swapsingh2712

One way of doing this

All comments

Hi @swapsingh2712

One way of doing this

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

录制_2023_01_30_08_47_18_479.gif

******

If it can help you get your want, please mark it as s solution and like for more share.

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

New Workflow5.yxmd

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/1075082#M266034

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703