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
