I have a year planner that has the date in column A
Columns B to AZ contain the weeks that work will occur.
What i want to do is lose Column A and condense A to AZ to be in one row. This will then show easily what weeks there is no work occuring.

Is this possible

cheers