Hi ,
Could you help me in getting the below results,
For ex i have data like
ID Pink Blue Red Green
1 1 0 1 0
2 0 0 1 1
3 1 1 0 0
4 0 0 1 0
5 1 1 1 0
Expected output:
ID Color
1 Pink
1 Red
2 Red
2 Yellow
3 Pink
3 Black
4 Red
5 Pink
5 Black
5 Red