ad hoc query - column not row
I have big problem in extracting report from ad hoc query.
The case is:
When I extract report from ad hoc query it will bring for example (passport and ID) in row wise not column wise. Also, I have this problem for: 1) basic salary, 2) transportation, and 3) housing. They are exporting in a row-wise, which makes it difficult for management to make analysis.
Is there a way to have all information to become in column wise not in a row-wise.
Your response is very much appreciated.