spudulene
New member
- Joined
- Aug 20, 2019
- Messages
- 20
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel 2019
I have seen solutions to this sort of problem solved using VBA, but know so little about programming I could not figure out how to apply it to my data.
I have the data below but have also attached the spreadsheet.View attachment guru.xlsx
Here is the input:
Here is the output I would like. I have hundreds of rows of data and would rather not transpose by hand for each student.
Any help would be appreciated.
Thank you in advance.
I have the data below but have also attached the spreadsheet.View attachment guru.xlsx
Here is the input:
Student | Course | Grade | ||
Student 1 | ZZZ 129 | B+ | ||
Student 1 | ZZZ 130 | B | ||
Student 1 | ZZZ 131 | B+ | ||
Student 1 | ZZZ 132 | A- | ||
Student 2 | ZZZ 127 | B+ | ||
Student 2 | ZZZ 128 | B+ | ||
Student 2 | ZZZ 129 | C | ||
Student 2 | ZZZ 130 | B | ||
Student 2 | ZZZ 131 | C+ | ||
Student 2 | ZZZ 132 | B | ||
Student 3 | ZZZ 129 | C | ||
Student 3 | ZZZ 130 | B | ||
Student 3 | ZZZ 131 | C- | ||
Student 3 | ZZZ 132 | B | ||
Student 4 | ZZZ 125 | B+ | ||
Student 4 | ZZZ 126 | B+ | ||
Student 4 | ZZZ 127 | C | ||
Student 4 | ZZZ 128 | B | ||
Student 4 | ZZZ 129 | C+ | ||
Student 4 | ZZZ 130 | B | ||
Student 4 | ZZZ 131 | C | ||
Student 4 | ZZZ 132 | B |
Here is the output I would like. I have hundreds of rows of data and would rather not transpose by hand for each student.
ZZZ 125 | ZZZ 126 | ZZZ 127 | ZZZ 128 | ZZZ 129 | ZZZ 130 | ZZZ 131 | ZZZ 132 | |
Student 1 | B+ | B | B+ | A- | ||||
Student 2 | B+ | B+ | C | B | C+ | B | ||
Student 3 | C | B | C- | B | ||||
Student 4 | B+ | B+ | C | B | C+ | B | C | B |
Any help would be appreciated.
Thank you in advance.