Columns into headers

[Nikhil2725]

Hi All,

I have a table as below:

Client_id,batch_id,Questions and Answers are the header in the table:

Client_id	batch_ID	Questions	Answer
15	85	1. Overall, what was your impression of the educational program?	A1
15	85	2. The program was successful in educating me about important financial concepts:	A2
15	85	3. The course work was relevant in helping me plan for and/or pay my monthly household expenses:	A3
15	85	4. I'm likely to make changes to my monthly finances as a result of the educational program:	A4
15	86	1. Overall, what was your impression of the educational program?	A21
15	86	2. The program was successful in educating me about important financial concepts:	A22
15	86	3. The course work was relevant in helping me plan for and/or pay my monthly household expenses:	A23
15	86	4. I'm likely to make changes to my monthly finances as a result of the educational program:	A24

However, Now i want to display as below: 

Client_id	batch_ID	1. Overall, what was your impression of the educational program?	2. The program was successful in educating me about important financial concepts:	3. The course work was relevant in helping me plan for and/or pay my monthly household expenses:	4. I'm likely to make changes to my monthly finances as a result of the educational program:
15	85	A1	A2	A3	A4

Kindly Help me in displaying as shown.

Regards,

Nikhil

[Channa]

try cross table

[Nikhil2725]

Hi,
Thanks for the reply...

Can u able to send the brief code about Cross table...

[ignacio_pena]

Hello,

You can use a Pivot Table with this configuration:

In the pivot table you should put the "Question" field as a column. The "Answer" field has been used as an expression with an Only (Answer).

Regards,

[Nikhil2725]

HI, Can u able to send the cross table code for the above mentioned code?

[Channa]

https://www.youtube.com/watch?v=3D5DnJ0DACk

have nice video bro it will help try

you just have function Crosstabl before