So I have a google form dumping data into spreadsheet tab form responses 1.

I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is =QUERY('Form Responses 1'!A2:J,"SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J"). Unfortunately, this doesn't show only the latest time stamp and for some reason the query has a weird effect of showing max in the formula cell with a spare row.

Any help would appreciated.