Hi,

I think you can use Pivot Concept to display Rows into Columns, but not sure about splitting the results into 2 rows as you expect.

Regards,

Sathish