Transposing Data in HCM Extracts

Content

Hello, 

I was looking into transposing the data / move rows to columns and vice versa in HCM Extracts. 

For example, lets say I need some element information to be returned from the extract. I pick up the element entry user entity, join / link it with the others that I have and get something that resembles the below table.

Assignment Number	Element Name	Input Name	Entry Value
123ABCD	Basic Pay	Amount	1000
123ABCD	Basic Pay	Periodicity	Annual
789EFGH	Special Pay	Amount	100
789EFGH	Special Pay	Periodicity	Annual

However, what I am looking for is the below table with the entry values grouped by Amount and Periodicity and transposed as columns with entry values as rows.