SQL & PL/SQL

Hi

I'm pretty new to SQL and I'm trying to reformat some output I'm getting. Basically I am querying a column and once the value in column A changes I want the data I'm pulling to be displayed in a new column. the output should like below where I have x number of columns of data dependent on the number of different values in column A.

Response Response Response
stringdata stringdata stringdata
stringdata stringdata stringdata
stringdata stringdata stringdata etc..


My current query is quite simple and I'm not sure how to go about modifying it.

SELECT
"JOB_CHECKLIST"."RESPONSE"
FROM
"XSPROD"."JOB_CHECKLIST" "JOB_CHECKLIST",
WHERE
"JOB_CHECKLIST"."JOB_NO" = "JOB_HISTORY"."JOB_NO"

Basically when the value in column job_no changes I want to format the output so that the data in response column is placed in a new column.

Hope this is clear.

Thanks in advance
Emma