Roster data

[jschreiber69]

Hello all,

I am try to convert an Excel file of course requests from thousands of rows of individual requests (all containing the Student id) to a create a new Workbook or sheet that contains 1 row of data per student with all the requests in separate columns. The number of requests per student is not a fixed number but the student id is on each line with their request. I figure this is pretty basic for people who know excel. We normally would just print out a report and give directly to students. Due to COVID-19, we are fully virtual and I will be using the new workbook or sheet that is created for an email merge. I have provided a short video to explain what I am looking for and would appreciate your help.

Thanks, Joe

Video explanation of Request

 

[mumps]

@Kenneth Hobson
Thanks for picking up on that since the Mac doesn't use the dictionary method . I should have been more careful to look at the OP's Excel version.

 

[jschreiber69]

@mumps and @Kenneth Hobson

Both of you are amazing. I just want to thank you so much for both of your solutions.
I was going to borrow my wife's laptop to run your solution but when Kenneth provided his solution, I stayed on my 27 inch and 32 inch monitors. After running the first time, I realized one of the students had only 1 request and that caused a type mismatch error (but helped me find this problem). After adding some basic requests and looking through the rest of the data, I ran the script again .... VOILA. This was exactly what I was looking for and I even learned a little by looking through your solutions.

Thank you very much,

Joe