Please help me with the sql query to retrieve a single row for each trip code which will combine all the rows of same trip code into one. For eg: in this example: ASSASSIN - 03 Sep 19 trip code had four columns.