Show Field Data in Column instead of in Rows

Summary

Working on this in OTBI

Content

Hi All,

I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using rank right now to get the last 2 dates for "regular date earned". 

Person Number	Name	Job Title	Regular Date Earned
12345	Doe, John	Usher	12/24/2020
12345	Doe, John	Usher	11/12/2020

I would like it so that the data appears like the below instead:

Person Number	Name	Job Title	Regular Date Earned 1	Regular Date Earned 2
12345	Doe, John	Usher	12/24/2020	11/12/2020

Is this achievable in OTBI? Please advise and thanks in advance.

Version

20D