Help in using best way to get the result required

I have an excel with the table structure shown below Role Name 1-Jan-23 10-Jan-23 20-Jan-23 30-Jan-23 10-Feb-23 20-Feb-23 Painter A P P A A P P Painter B A P A P P P ...