How do I extract the dates and paste them in a separate single cell?

Hi, how do I extract the dates that the person is absent and paste all the dates in a single separate cell? Thanks!

For a name row, when there is no value you want the corresponding header to be concatened in the cell in column AQ is it?
The header is not with date.
What is you final need to group data in the same cell?

Hi PCI, yes the output (which is what I want is in column AQ). Sorry I forgot to add the header to column AQ.
I need to do mail merge with the dates as I need to send out forms with the dates they were absent in the period of time.
Just that the code cannot run for certain rows eg. Rows 23

Try next code

Please Login or Register  to view this content.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.