Macro to Create a New Spreadsheet Based on Another [Closed]

Report
Posts
1
Registration date
Monday August 28, 2017
Status
Member
Last seen
August 28, 2017
-
Hello,

I have the following problem. I have a spreadsheet in which I record some information regarding an employee and all the exams he has been submitted to:

http://static.ccm2.net/ccm.net/pictures/kcRy6krcwXH5FOkkcNjaphgVyCGI89yn1LLfOYOAr5akLR82WNNGxhUtgENrMBNs-screen-shot-2017-08-28-at-10-10-58.png

As you can see, the columns "Date" and "Exam" are repeated for each exam the employee has been submitted to. However, I want to change the structure of the table so that a new entry is created for each exam the employee is submitted to, repeating all the information preceding the exam date:

http://static.ccm2.net/ccm.net/pictures/IkhFo8SqRZLMe8UnRyE9Aj0Q7DvzWzHHzHvF8hsWEatTT9MaGHax9i0dSNRa12gc-screen-shot-2017-08-28-at-10-11-10.png

The problem is that I have a massive amount of data, therefore I'd need a macro to do that transformation efficiently. How can I create a macro to do that transformation for me?

Thanks in advance!