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 write query to to pivot the necessary columns. Attached is the original data in excel & a spreadsheet with the 1st few cases pivoted.