I want to merge them into one row.

The year planner is quite big and what i want to see is if every week is covered for the whole year, well except holidays of course.

I have tried a pivot table but i get lost some where, oh and i am a numpty at macros