I have a query that I would like the results to be in columns not rows, but I do not want the column names to be the row result names.
TRANSFORM First(part_id) AS FirstOfPartID
SELECT part_id, id
GROUP by PART_ID, ID
Here is the query results and the how I would like the table to look. I spent a couple hours looking for answers and I think I may need code for this.
I can modify the data in excel as well, if that is easier, but I do not know how to do that either.