Solved consolidate multiple rows into one line (1 Viewer)

[Number11]

I am looking for a way to consolidate multiple rows into one line for the following results

Customer_ID	Start Date	Last order	PkID	Last Contact Name
1444	01/01/2022
1444		28/06/2022
1444			323232
1444				Bob Smirth

Output required...

Customer_ID	Start Date	Last order	PkID	Last Contact Name
1444	01/01/2022	28/06/2022	323232	Bob Smirth

Any ideas please

 

[pbaldy]

Create a query that returns those fields. Click on the Totals icon on the ribbon. Leave the first field on Group By, change the others to Max. Run it and see if that gets the desired result.