hi team, here is my data set looks like and the output as well. please help me with the approach
input
custmer id gender confirm
123 male,male,female yes,yes,yes,yes,yes
456 female,male,male no,yes,yes,yes
789 male,female,female yes,no,no,yes,yes
output
sl.no custmer id gender confirm
1 123 male yes
1 123 male yes
1 123 female yes
2 456 female no
2 456 male yes
2 456 male yes
3 789 male yes
3 789 female no
3 789 female no
thanks in advance
@rag329
I usually use the combination of Transpose, Cross Tab and Tile for this kind of problem.