Hi Team,
I have a table of content shown as below (1) and I would like to transform that as (2). Can someone please help me with the solution?
1:
| Record ID | Q1 | Q2 | Q4 |
| 1 | Y | Y | Y |
| 2 | N | Y | Y |
| 3 | N | Y | N |
| 4 | Y | Y | N |
| 5 | N | Y | N |
Expectation
2:
| Record ID | Response | Q |
| 1 | Y | Q1 |
| 2 | N | Q1 |
| 3 | N | Q1 |
| 4 | Y | Q1 |
| 5 | N | Q1 |
| 1 | Y | Q2 |
| 2 | Y | Q2 |
| 3 | Y | Q2 |
| 4 | Y | Q2 |
| 5 | Y | Q2 |
| 1 | Y | Q4 |
| 2 | Y | Q4 |
| 3 | N | Q4 |
| 4 | N | Q4 |
| 5 | N | Q4 |
Regards,
Venamma
