Turn table into a list

I have this table of what people are missing on each month, and what are they missing(maked as missing) or they have(marked with an "X") or if the guy wasn't working at that time, it says not working.

This is the table layout Table Layout

I want to turn that into a list with all the missing months of each thing so it can look maybe like this

Year 2023
Worker1_name
NÒMINA:(Months missing here)
REGISTRE DE JORNADA:(Months missing here)

Year 2023
Worker2_name
...

And so on so forth, I don't know if this is possible though.

Here's a quick attempt; I'm not sure how to get the years, so I have used a fixed string. This requires Microsoft 365. You can check the steps by changing result to months, register etc. Please look up the references for LET, LAMBDA etc. from here: LET function - Microsoft Support

Enter the following in the first cell for the results:

=LET(
    header, A3:T3,
    payroll_data, A4:T26,
    comment_1, "Take first row, drop the first column when needed",
    employee_names, DROP(header, , 1),
    months, TEXTBEFORE(CHOOSECOLS(payroll_data, 1), " "),
    register, TEXTAFTER(CHOOSECOLS(payroll_data, 1), " "),
    result, REDUCE(
        "Missing months for employees",
        DROP(employee_names, , 1),
        LAMBDA(list, name,
            LET(
                is_missing, CHOOSECOLS(payroll_data, XMATCH(name, employee_names)) =
                    "Missing",
                missing_months, LAMBDA(name, for_register,
                    for_register & ": " &
                        ARRAYTOTEXT(
                            FILTER(months, (register = for_register) * is_missing, "--")
                        )
                ),
                VSTACK(
                    list,
                    VSTACK(
                        "Year 2023",
                        name,
                        missing_months(name, "NÒMINA"),
                        missing_months(name, "REGISTRE DE JORNADA"),
                        ""
                    )
                )
            )
        )
    ),
    result
)