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

E

eduams

New Member
Joined
Sep 26, 2016
Messages
1
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.:
[TABLE="class: grid, width: 768"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Science Term 1[/TD]
[TD]Science Term 2[/TD]
[TD]Science Term 3[/TD]
[TD]Science Term 4[/TD]
[TD]Maths Term 1[/TD]
[TD]Maths Term 2[/TD]
[TD]Maths Term 3[/TD]
[TD]Maths Term 4[/TD]
[TD]English Term 1[/TD]
[TD]English Term 2[/TD]
[TD]English Term 3[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]92[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]84[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD="align: right"]79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD="align: right"]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD="align: right"]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]66[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]78[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]41[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]71[/TD]
[TD][/TD]
[TD="align: right"]57[/TD]
[/TR]
[TR]
[TD]Thu[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]44[/TD]
[TD][/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]35[/TD]
[TD][/TD]
[TD="align: right"]84[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]88[/TD]
[/TR]
</tbody>[/TABLE]

..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
 
You must log in or register to reply here.

Similar threads

N
  • Solved
Total of marks with the specific conditions
2
Replies
11
Views
452
Eric W
Eric W
D
  • Solved
Groupby include only counta < 4
Replies
5
Views
264
Alex Blakenburg
A
GMC The Macro Man
  • Question Question
SEQUENCE formula
Replies
0
Views
253
GMC The Macro Man
GMC The Macro Man
togenmoser
  • Solved
Finding all possible combinations of 2 sums
2
Replies
10
Views
766
togenmoser
togenmoser
M
  • Solved
Macro to merging for multiple columns contain same headers
Replies
6
Views
174
Maklil
M

Forum statistics

Threads
1,226,840
Messages
6,193,279
Members
453,788
Latest member
drcharle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top