Morning everyone, I'm trying to get a pivot query to work on the below data source. My aim is to get the CarId to be the column headers and the axle serial as the data source all on 1 row. the table name MTDN is actually a query that gets the information I need into 1 place.
Table: should be an...