jschreiber69
New Member
- Joined
- Mar 6, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- MacOS
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
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