How to solve...

Training Webinar Attendance Log

$\backslash$table$[[$Employee$,$Webinar $1,$Webinar $2,$Webinar $3,$Webinar $4,$Complete?$],[$Claire$,$Yes,Yes,No$,$Yes,$],[$Susan$,$Yes,Yes,Yes,Yes,$],[$Lucy$,$Yes,Yes,Yes,Yes,$],[$Mike$,$Yes,Yes,Yes,No$,],[$Ming$,$No$,$No$,$No$,$No$,],[$Vinit$,$Yes,Yes,Yes,Yes,$],[$Adam$,$Yes,Yes,Yes,No$,],[$Ben$,$No$,$Yes,No$,$No$,],[$Oliver$,$Yes,No$,$No$,$Yes,$],[$Jasmine$,$Yes,Yes,Yes,Yes,$],[$Rose$,$Yes,Yes,Yes,Yes,$],[$Tilly$,$Yes,Yes,Yes,Yes,,$],[$Penelope$,$Yes,No$,$Yes,No$,],[$James$,$No$,$Yes,Yes,No$,],[$Becky$,$Yes,No$,$No$,$Yes,$],[$Les$,$Yes,Yes,Yes,Yes,$]]$

Notes:

Attended all webinars $=$ Complete

Did not attend all webinars $=$ Incomplete