Hi All

I am looking for a solution to the following problem:
...I need to create a mail merge of all students with grades in subjects they study for only. If they study for those subjects then i want to return the subject and grade under each students name. If they don't study for any subject, then i don't want to see the subject listed at all...e.g.:
[originally posted here [URL="http://www.mrexcel.com/forum/excel-questions/966936-excel-mail-merge-return-column-headers-all-any-columns-values.html"]

..so the final outcome should be a single page with customized headers and merged fields like:

Name: Mar
Subjects:
Science Term 1: 72
Science Term 2: 47
Science Term 3: 18Maths Term 2: 44
_________________________________next student record

many thanks for your help