Multiple Lookups in several columns

[Zakky]

Hello,
I have a long list of employees that shows the hours they worked each month. Is there a quicker way of identifying months that each employee worked in. Ideal answers would look something like in Column J & K. At the moment i am inputting answers manually. I uploaded a file with data.
Thank you.

 

[kevin9999]

Like this perhaps?

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	HRS worked.
2	Employee	July	Aug	Sep	Oct	Nov	Dec	Jan	G Total	Answer	Answer
3	J	3		2	2		1		8	July, Sep, Oct, Dec	4
4	M	47	19	5	15	25	25	11	147	July, Aug, Sep, Oct, Nov, Dec, Jan	7
5	J	1							1	July	1
6	B			6	2		6		14	Sep, Oct, Dec	3
7	K							2	2	Jan	1
8	R								0	No Hours	0
Sheet1

Cell Formulas
Range	Formula
I3:I8	I3	=SUM(B3:H3)
J3:J8	J3	=TEXTJOIN(", ",TRUE,FILTER($B$2:$H$2,B3:H3<>"","No Hours"))
K3:K8	K3	=COUNTA(B3:H3)

 

[SunnyAlv]

Try like this, just need one formula

=LET(month,$B$2:$H$2,worked,B3:H3,answer,FILTER(month,worked<>""),IFERROR(HSTACK(TEXTJOIN(", ",,answer),COUNTA(answer)),"No Hours"))

 

[Zakky]

Kevin9999 & SunnyAIv thank you for the prompt replies. Both answers work perfectly well. Many thanks for making my life easier. Have a good day.