Thanks for the feedback & the articles.

Well it looks like it says that for each question in the QuestionID column, return the maximum...

You ROCK! 😀

Thanks for cleaning that up. And that's right, you did say that bmp should be the desired results. Here you go.

Okay, I did this both ways in the hopes that one would be correct. I have attached bitmap file & I created a query using the instructions in the "Forum...

Allow me to try again. The original file comes from an excel spreadsheet that I pull into SPSS & then export to a table in SQL. Then I wanted to...