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
Solved! Go to Solution.
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