Reconfigure Data to make it usuable

Hi all,

Thank you for all and any help in advance!

I have an export from a site (which I am unable to edit) which is giving the data in a layout that I am unable to use - it as got the week end date and then Mon, Tues, Weds... columns which means I can't do a SUMIF function as each row doesn't have it own date:

Is it possible to convert this:
Company, Week End, Location, Job Type, Mon, Tue, Wed, Thu, Fri, Sat, Sun,
ABC Company, 05/06/2022, Site 1, Job 1, 11, 11, 0, 11, 11, 11, 11,
DEF Company, 05/06/2022, Site 2, Job 1, 11, 0, 0, 11, 11, 11 11
GHI Company, 05/06/2022, Site 3, Job 4, 11, 11, 11, 0, 11, 0, 0,
JKL Company, 12/06/2022, Site 2, Job 2, 0, 0, 0, 0, 0, 11, 0,

To this:
Company, Day, Location, Job Type, Hours,
ABC Company, 30/05/2022, Site 1, Job 1, 11,
ABC Company, 31/05/2022, Site 1, Job 1, 11,
ABC Company, 01/06/2022, Site 1, Job 1, 0,
ABC Company, 02/06/2022, Site 1, Job 1, 11,
ABC Company, 03/06/2022, Site 1, Job 1, 11,
ABC Company, 04/06/2022, Site 1, Job 1, 11,
ABC Company, 05/06/2022, Site 1, Job 1, 11,
DEF Company, 30/05/2022, Site 2, Job 1, 11,
DEF Company, 31/05/2022, Site 2, Job 1, 0,
DEF Company, 01/06/2022, Site 2, Job 1, 0,
DEF Company, 02/06/2022, Site 2, Job 1, 11,
DEF Company, 03/06/2022, Site 2, Job 1, 11,
DEF Company, 04/06/2022, Site 2, Job 1, 11,
DEF Company, 05/06/2022, Site 2, Job 1, 11,
GHI Company, 30/05/2022, Site 3, Job 4, 11,
GHI Company, 31/05/2022, Site 3, Job 4, 11,
GHI Company, 01/06/2022, Site 3, Job 4, 11,
GHI Company, 02/06/2022, Site 3, Job 4, 0,
GHI Company, 03/06/2022, Site 3, Job 4, 11,
GHI Company, 04/06/2022, Site 3, Job 4, 0,
GHI Company, 05/06/2022, Site 3, Job 4, 0,
JKL Company, 06/06/2022, Site 2, Job 2, 0,
JKL Company, 07/06/2022, Site 2, Job 2, 0,
JKL Company, 08/06/2022, Site 2, Job 2, 0,
JKL Company, 09/06/2022, Site 2, Job 2, 0,
JKL Company, 10/06/2022, Site 2, Job 2, 0,
JKL Company, 11/06/2022, Site 2, Job 2, 11,
JKL Company, 12/06/2022, Site 2, Job 2, 0,

Example Reconfigure.xlsx

Thank you in advance!