Convert PR261 to easy to read format

Has anyone had the need to replicate the PR261 report but in LBI, with the goal of being to be able to read it in a simple format, export to Excel, and run any necessary calculations against the fields for auditing purposes? Our payroll department uses this report to ensure the taxable wages are appearing correctly, but the format is not ideal for auditing purposes. Payroll has requested a format that would display one row per employee, with each deduction code appearing in it's own column with the value underneath.

My thoughts are if anyone has created anything like this that I could peek at the SQL code or view a Crystal template? Thanks for your assistance!