Macro to convert data to a more standard form?

[REvans81]

I'm not really sure how to explain this... basically I get reports on student grades for tests/projects on different dates. THe report that's generated can export to excel but it's not the easiest to work with. I'd like to make a macro to convert this data to a different format (Like student names in rows, classes in columns, scores in the cells) but the classes and size of the data set is going to vary. Ultimately, I'd like to make a pivot table with the converted data as we have a third party requesting it in this format.

sample report:

Student Name <tbody> </tbody>		Date	Class	Score Type	Score
Suzie H <tbody> </tbody>		1/2/2018 <tbody> </tbody>	282 - Math 1	Quiz <tbody> </tbody>	90
		1/8/2018 <tbody> </tbody>	778 - Geography <tbody> </tbody>	Quiz <tbody> </tbody>	87
		1/11/2018	117 - Social Studies <tbody> </tbody>	Homework <tbody> </tbody>	89
		2/4/2018 <tbody> </tbody>	282 - Math 1	Homework <tbody> </tbody>	89
		2/7/2018 <tbody> </tbody>	282 - Math 1	Homework <tbody> </tbody>	95
		2/12/2018 <tbody> </tbody>	778 - Geography <tbody> </tbody>	Quiz <tbody> </tbody>	77
Suzie H	Sponsor: Jim K	Average			87.83
Jimmy R		1/2/2018 <tbody> </tbody>	286 - Math 2 <tbody> </tbody>	Homework	85
		1/8/2018	134 - Earth Science <tbody> </tbody>	Quiz	89
		1/9/2018 <tbody> </tbody>	117 - Social Studies <tbody> </tbody>	Homework	84
		1/10/2018 <tbody> </tbody>	286 - Math 2	Homework	90
		2/2/2018 <tbody> </tbody>	778 - Geography <tbody> </tbody>	Homework	89
		2/8/2018 <tbody> </tbody>	778 - Geography <tbody> </tbody>	Project	85
		4/5/2018 <tbody> </tbody>	286 - Math 2	Homework	77
Jimmy R	Sponsor: Jim K	Average			85.57

<tbody>
</tbody>

The only items I really care about are the names, dates, class, and score (I don't need sponsor, average, or score type). I don't care what it looks like when it's converted, I just have to be able make a pivot table with the data.

I haven't had any formal training and I'm not very good at starting visual basic projects so I don't really know how to kick it off but nobody else here knows much of anything about excel. I know how to make pivot tables and I can usually tinker with the code after it's written in order to tweak it a bit.

If anyone is able to assist, I'd appreciate it!!!

 

[Fluff]

Glad to help & thanks for the feedback