Macro on exel, with reading from sheet 1 to sheet 2?

Question

Macros

There is sheet 1 in which there is a list of surnames and days of the week in which they were at work .

From it, you need to display a line containing the days of the week in which he was at work
. Like this:

Many thanks in advance. Tried to do it doesn't work. Please help me with code to optimize this routine work)))

Answer 1

For Excel:

=еслиошибка(
ПСТР(
        ЛЕВСИМВ($B$1&",  ";B2*4)&
        ЛЕВСИМВ($C$1&",  ";C2*4)&
        ЛЕВСИМВ($D$1&",  ";D2*4)&
        ЛЕВСИМВ($E$1&",  ";E2*4)&
        ЛЕВСИМВ($F$1&",  ";F2*4)&
        ЛЕВСИМВ($G$1&",  ";G2*4)&
        ЛЕВСИМВ($H$1&",  ";H2*4)
        ;1
        ;СУММ(B2:H2)*4-2
        )
)

For Google Sheets:

=еслиошибка(join(", ";filter($B$1:$H$1;B2:H2<>"")))

Demo table