Display multiple values as new values based on selection from template.

[MvdB]

MS Excel 2013:


I have a spreadsheet with subject (module) examination details that are used for a Mail Merge document. The subjects are listed in a template from "Module 1" to "Module 8" respectively, each with its own consequent date, duration and time values. This template is used to inform students of their applicable examination dates, duration, times, venues and invigilator details.

The problem starts when students have to write a second opportunity.
When the subjects are marked with an “X”, I require the information to be displayed in a new table as per example provided (This is also required to accommodate a second Mail Merge, but is not the primary objective here).
I have no idea how to go about in achieving this.

Any assistance shall be greatly valued.

[Pecoflyer]

Could you please provide a sample sheet ( pics are useless to work with). Thx

[macropod]

From what I can make out from your pic, all you need is to filter the data on column B. A mailmerge can likewise filter data, so I doubt you'll need a separate table for that, either.