I have a query that returns 4 lines per ID. I would like to be able to merge these into one single row in a new table, based on the ID and Date.
Can anyone help? I've researched and seem can't find any examples.
simplified version of how the data looks at the moment: