Transforming row values as columns

system_migrated

Hi,
I have table that return values like below.

Employee Id| Questions | Answer

---

1 | question1 | answer1
1 | question2 | answer2
1 | question3 | answer3
2 | question1 | answer1
2 | question2 | answer2
2 | question3 | answer3


I wanted to show them in Birt report as

Employee | question1 | question2 | question3

---

1 | answer1 | answer2 | answer3
2 | answer1 | answer2 | answer3

Please let me know how can I achieve this?

Thanks in advance