Transpose rows to columns in OTBI

Summary

I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBI

Content

Hi

I hope you can help me. I need to build a report that shows every employee as a column.

Example:

Person ID	Person Start Date	Last Name	Person Gender	Creation Date
300,000,043,368,135.	04/06/2020	Test	Male	04/06/2020 14:07 t
300,000,043,368,847.	08/06/2020	Galvan	Male	09/06/2020 12:54 t
300,000,043,648,474.	04/06/2020	Test	Male	04/06/2020 14:21 t

 

In need to show it like this:

 

Person ID	300,000,043,368,135.	300,000,043,368,847.	300,000,043,648,474.
Person Start Date	04/06/2020	08/06/2020	04/06/2020
Last Name	Test	Galvan	Test
Person Gender	Male	Male	Male
Creation Date	04/06/2020 14:07 t	09/06/2020 12:54 t	04/06/2020 14:21 t
Email Type		Work Email

 

I was trying to use Pivot Table, and moved all rows to columns, however I cannot  find how to put the header in the first columns. I got something like (without header in row).