So I have a table full of data which looks like this:
Subject A Subject B Subject C Subject D Count
Person A F F F 3
Person B F F F 3
Person C F F 2
Count 2 2 2 2
And for each person, I need to print out a note for them, which looks something like this.
Person A
Subject A
Subject B
Subject D
Person B
Subject A
Subject B
Subject C
Person C
Subject C
Subject D
So, it should be vertical instead of horizontal. There are about 930 students and 17 subjects. Also, there are 4 columns for each student's class, id, name, and number.
Is it possible to do it with just Excel functions or does VBA must be implemented?
I can also write so Visual Basic application, is it possible to use Visual Basic to read in the data and generate a Excel file as result?
If excelmfunction is to be used, please tell me what function to use. If VBA is to be used, please tell me the guide or function to follow. If VB is to be used, please tell me the used APIs.
EDIT: Since I need a bunch of little notes, how about Mail Merge with Word? Is it doable?