Un pivot data set

[Venamma]

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

[Emmanuel_G · Accepted solution]

Hi @Venamma ,

Find attached the way of doing this.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

[Luke_C · Accepted solution]

Hi @Venamma 

Use the transpose tool:

[Venamma]

Thank You very much for the quick response.