Add Rows based on other columns

[swapsingh2712]

Hello All,

I've a data set which looks kinda below

ID	Issue_1	Issue_2	Issue_3	Issue_4
1	aaa		ggg	iii
2	bbb	eee		mmm
3	ccc	fff
4	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

ID	Issue_1
1	aaa
1	ggg
1	iii
2	bbb
2	eee
2	mmm
3	ccc
3	fff
4	ddd
4	hhh
4	kkk

so Basically the values mentioned for each id should come in different rows.

Could you please advise

KR

Swap

[ShankerV]

Hi @swapsingh2712 

Please find the expected output.

Many thanks

Shanker V

[ShankerV]

Hi @swapsingh2712 

Step1 : Input

Step 2: 

Step 3:

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @swapsingh2712 

Step 4: Filter tool

Step 5:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V