Duplicate rows, some data in each row's Columns. How to consolidate?

Hi everyone, new to this Forum, though I've used MS Suite for several years.

This is an issue I've encountered a few times before, and due to low volume of items, I painstakingly solved by hand.
Wondering if there is an easier way to go about it. Here is the situation:

I have a survey made by people. Say 10 people, answering 20 questions.
So when I get the CSV, the rows show as follows (let me see if I can illustrate)

[Dashes are spaces, to show empty cells]

-------A1----------A2-------A3-------A4-------A5-------A6--------A7
1--Person 1--Answer1-----------Answer3------------------------Answer6
2--Person 1-----------Answer2------------Answer4--Answer5------------
3--Person 2-----------Answer2--Answer3------------Answer5--Answer6
4--Person 2--Answer1-------------------- Answer4------------------------

If I had -say- 10 people, I'd simply drag and drop the cells into one of the rows, and delete the now empty duplicate.
But how to do it with larger amounts of data?

Thanks much, Happy Holidays to everyone.

(Forgot to mention, Excel 2016 PC/Mac)

Can you put that in a workbook and show a before and after