I'm new to crystal reports 2020 and need help with getting some data from rows into columns. The report will be exported into excel. Here is an example of the data right out of the table.

ActionID    TranID  FinDept Total Percentage
544            5    F551300   60
544            4    F554000   20
544            3    F556501   20
366            1    F551016   50
254            6    F551052   20
366            2    F555462   50
254            7    FF55001   80

The outcome I want to accomplish is this:

ActionID    FinDept1    Total Percentage1   FinDept2    Total Percentage2   FinDept3    Total Percentage3
544         F556501      20                 F554000     20                  F551300      60
366         F551016      50                 F555462     50      
254         F551052      20                 FF55001     80      

Any help would be greatly appreciated.