Merging parts of rows...

[Aasta]

Basically, what I have here is an Engineer who looks after multiple sites and can visit the site multiple times during the year (no more than once a month). I have a table recording when visits are due, and when they are completed.

I need to produce a summary report which will have:

• The site code
• A column for each month:
  
  • If a visit is due in a specific month, the column generates an X in the field. This'll let me colour it in later on. (If there's a way to do this without sticking a random letter in for conditional formatting, do let me know)
  • If the due visit is completed, I am also printing the date is was completed into the field
  
  

Now, this is where I'm not sure where to go to. As you can see in my picture, each month is going to be on a new line. What I need advise on is getting everything for the one site to be on the one line, otherwise the report will look naff and also be over 400 pages long just for this one store.

Any help is really appreciated,

Alex




Edit: Solved. I set the totals to Group By for engineer/code and set the months to Max.