Concatenate text based on criteria with comma separated

[andersen_yunan]

Hi, I got this raw data that shows list of people who do delivery packages in a month

	MON-1	TUES-1	WED-1	THURS-1	FRI-1	SAT-1	MON-2	TUES-2	WED-2	THURS-2
Andrew		12,00		12,00			12,00
Ashely	12,00		11,00							12,00
Alan		12,00			12,00			12,00	12,00
Billy						12,00
Charlie		12,00						12,00	12,00
William			12,00	12,00
Wilbert							12,00

<tbody>
</tbody>

and I want to make a summary data that would show people with their delivery day like this

	Visit Day
Andrew	TUES-1,THURS-1,MON-2
Ashely	MON-1,WED-1,THURS-2
Alan	TUES-1,FRI-1,TUES-2,WED-2
Billy	SAT-1
Charlie	TUES-1,TUES-2,WED-2
William	WED-1,THURS-1
Wilbert	MON-2

<tbody>
</tbody>

Is there any formula that I could use to have result like this?
Any help would be appreciated. Thanks in advance!

 

[mole999]

Second warning about reading the rules. If people don't answer original questions you might bump that thread once a day.
This is a repeat post, and as such I am locking this thread.
Use > https://www.mrexcel.com/forum/excel...in-text-comma-separated-list.html#post5028839 to continue