replacing nested if statements with some kind of VBA loop?

Hi tigeravatar,
Thanks so much for the help! This is really close, but doesn't quite do what I want, since often the major is listed for several semesters before it changes (and sometimes it's blank in between), for example, like this:

1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16		1st	2nd	3rd
MAT		MAT	MAT		NUR		NUR	SCI				SCI					MAT	NUR	SCI

Is there a way to modify your array formula so that it also works in this case?