Look up data from multilple columns and insert in one cell using a comma to seperate

I have a data set that I wish to look up the data from one column and if it is greater then 0 write it in another column separated by commas. Here is an example:

The data is dates that a service was provided and how many time that day it was done and not everyone gets the service on the same days.
I would like to summarize the days of the month that service was provided not number of times into 1 cell.


A B C
Row 1 November
Row 2 1 5 15
Row 3 1 0 2
Row 4 0 1 3

November is in A3

If A2 is greater then 0 I want to write A1 A2
If A2 and A3 is greater then 0 I want to write A1 A2, A3
If A2 is 0 and B2 is greater then 0, I want to write A1 B2

I have been battling this for days any help would be great
Thanks

a b c d
1 Month November
2 Date 1 3 5
3
4 Jay 0 1 1 In this case I would want to write November 3,5
5 John 1 1 1 In this case I would want to write November 1,3,5
6 Roger 1 0 0 In this case I would want to write November 1
7 Frank 0 1 0 In this case I would want to write November 3

I don't know how to upload the workbook. Is this a little clearer, its my actual data. The numbers next to the names mean I provided the service. 0 means I did not and the one means I was there 1 time that day.
What I want written as I wrote next to the data is that I was there in November on days x,y,z.
Is this a little clearer?
Thanks

Month November
Date 1 3 5

Jay 0 1 1 November 3, 5
John 1 1 1 November 1, 3, 5
Roger 1 0 0 November 1
Frank 0 1 0 November 3
Bill 0 0 1 November 5
Mike 1 0 1 November 1, 5
Jacob 2 1 0 November 1, 3

Here is a solution using an IF statement:
=IF(AND(B4>0,C4>0,D4>0),$B$1&" "&$B$2&", "&$C$2&", "&$D$2,IF(AND(B4>0,C4>0),$B$1&" "&$B$2&", "&$C$2,IF(AND(C4>0,D4>0),$B$1&" "&$C$2&", "&$D$2,IF(AND(B4>0,D4>0),$B$1&" "&$B$2&", "&$D$2,IF(AND(B4>0,C4=0,D4=0),$B$1&" "&$B$2,IF(AND(B4=0,C4>0,D4=0),$B$1&" "&$C$2,IF(AND(B4=0,C4=0,D4>0),$B$1&" "&$D$2,"")))))))

This accounts for all scenarios that may result when there are three Dates in one month. If additional Dates were added, this IF statement would need significant expansion.

THANKS!! That look like what I was getting at.
That's quite an IF string

and of course, I have a month with more then 3 days. I'' see what I can figure out

Thanks, that is way above my head, How do I insert that into my spreadsheet?

Thank you again, I have attempted to upload the workbook.

that is my actual workbook. As it stands today. The service provided is snow removal so its hard to determine the number of columns ( days of the month). I thought if I had a base I could build from there by inserting columns as I need them. If you use this set as an example can I insert columns with in the parameters of this base and have it still work?
The data shouldn't extend past March but how many days no one knows.
sorry for the misleading example, I did not realize how complex this was
Thanks again

You're welcome.

After thinking through the limitations of the IF statement, I came up with a solution that uses a VBA macro and button to perform the same function more dynamically. This solution would allow you to add dates, and/or add users to your example without having to worry about updating an IF statement and copying it each time you change the variables. When using IF statements, it would not only be tedious each time you make updates, but eventually you will run into the argument limit in Excel as each date added would exponentially increase the number of IF statements required.

In the attached example, I've created a button (at the top right), which is tied to a VBA macro (CompleteVisits) that when pressed will instantly update the values in the column containing "Visits On:" in row 3. Try adding a name, and/or dates across the top, then complete the data and press the Complete Visits button.

NOTE: When you add a date in row 2, be sure to add a column so that you always have a blank column to the right of your data.

Check out the attachment (macro-enabled) for this more in-depth solution.

This example does not account for multiple months. Only multiple days within a month.

Thank you for clarifying that. The second file (the larger one) should be the way I want it to look.

Hello Richard,

That attached file does not appear to be working.

its telling me compile error, variable not defined when visual basic opens
yes I did tell it to enable macros