Need Listing Formula With Criteria for a KP Chart

I'm trying to help a non-profit group with a "KP Chart" for their camping trip and just know the basics for Excel 2016 formulas. So, having a hard time with figuring out what to do for a formula that would actually work.

 

What I have to work with is exampled like below for data (only the list is much larger), which is First & Last Names with Job codes under days of the week.

 

First Name:  Last Name:  Mon:  Tues:  Wed:  Thurs:  Fri:
Jim                Carson          MB      N        PL        LD       MFB
Mary             Carlson         N         EDW   MS      EC       MB
Tom              Dodge          EDW    MC     PL       LD        MFB
Sally             Jones             N         FL       EC       MS        EFB
Susie            Keys              MS       EDW   N         LJ        MC
Jerry             Ladd              N        MB      PL        LD       MFB

What I need the formula to do on a Daily Job chart is make a list of names under each job, just showing First Name and Last name combined under the Job they get for the day, extra spaces without names I need to show as blank spaces too, as the number of people vary each day. As example below:

 

MONDAY NOON LUNCH: (which are assigned with letter "N" under "Mon")
Mary Carlson
Sally Jones
Jerry Ladd
                 =(a blank space if no extra names assigned)
                 =(a blank space if no extra names assigned)

 

I am aware that I could combine the names into a third column "Both Names" like this using this formula =(A1&" "&B1;) So that the data file could look like this:

 

First Name:  Last Name:  Both Names:  Mon:  Tues:  Wed:  Thurs:  Fri:
Jim                Carson           Jim Carson      MB      N        PL       LD        MFB
Mary             Carlson          Mary Carlson   N        EDW   MS      EC        MB
Tom              Dodge           Tom  Dodge    EDW   MC     PL        LD        MFB
Sally              Jones             Sally Jones       N        FL       EC       MS       EFB
Susie             Keys               Susie Keys       MS      EDW   N        LJ         MC
Jerry              Ladd              Jerry Ladd        N        MB      PL       LD       MFB

 

But what formula would work so I can get this listing as the final result for each day job?

 

MONDAY NOON LUNCH: (which are assigned with letter "N" under "Mon")
Mary Carlson
Sally Jones
Jerry Ladd 
                 =(a blank space if no extra names assigned)
                 =(a blank space if no extra names assigned)