Excel / Mail Merge - Return Column Headers for All and Any Columns with Values

[eduams]

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.:

Name	Science Term 1	Science Term 2	Science Term 3	Science Term 4	Maths Term 1	Maths Term 2	Maths Term 3	Maths Term 4	English Term 1	English Term 2	English Term 3
Jan								61	50	0	81
Feb								18	17	14	5
Mar	72	47	18			44
Apr	25	81	99			34	29	89	55	74	92
May	28	28	84			37	50	1	23	72	52
Jun	79					93	11	90	8	63	89
Jul	32					18	73	7	65	24	54
Aug	22					67	6		2	84	66
Sep				61	64	17	45	59	58	65	80
Oct				27	34	9	30	11	1	42	78
Nov
Dec
Sun	55
Mon	41
Tue	56
Wed	39	48	83	56	18		75	37	71		57
Thu	75	87	55	17	44		56	26	21		5
Fri	99	94	70	42	14	7	83	75	35		84
Sat	39	9	59	57
Sun	79	56	80	11
Mon	17	49	67	3	70	68	64	33	31	15	88

<tbody>
</tbody>

..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