Move row data into columns
I am trying to use the Incident Audit Log as the basis for an incident status progress report and would like to only have one row in the report per incident ref showing the dates/time a status changed occured as columns within that row. At present each status change creates a row in the "transaction" table and so my report has multiple rows per incident ref.
What I would like to achieve is a row with these fields from the Incidents table:
ref_no | product_id | date_created
And then add to it 3 columns based on Transactions table data where "trans_type = Changed Status" - it is this that is currently giving me rows that I don't want!