How to change data in a request from line to column

I have a request looking like this : Dealer name Function Name Site A Sales director Mr A Site A After sales director Mr B Site A HR director Mr C Site B Sales director Mr D...