Group and transpose data

I need data in Column a to be grouped in rows, and the values for "Answer" to be associated horizontally in the row with the earliest rating by date on the left. I attached some of the file.

thank you very much.