Pivot Data from/In Expression Rule

Hello!

We are attempting to create a read only grid which will allow the users to export to excel (so data must be a record type) to filter the relevant data into groupings we have an expression rule however the outputs will need to be pivoted to display in a way that is readable/logical on the grid

Data from rule example-

raisedBy: Username1
Status: Complete
Count item: 2
Level:1

raisedBy: Username 1
Status: Complete
Count item: 3
Level: 2

We would want to display this data pivioted i.e.  

RaisedBy                                 Status                             Level:1              Level: 2
Username1                              Complete                           2                        3

Currently we can only display this data as shown below

RaisedBy                                Status                               Level: 1               Level:2
Username 1                            Complete                                5                      5 
Username 1                            Complete                                5                      5


I cannot find information on how to pivot data in Appian is this perhaps called something else?  Is there a way to achieve this in Appian any help would be appreciated!

Thank you!