I have a Pivottable with appointments for the upcoming week per client. I want to print this out and distribute it. To be able to do this I need to have only 1 client per page. Seeing that a client can have multiple appointments and that the number of appointments per client differ, I cannot seem to make that happen.
So what I want is that the data from the first field is seperated per page.
patient 1 - appointment 1
- appointment 2
patient 2 - appointment 1
Does anyone have any ideas or maybe a script?
Please sign in to leave a comment.