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

What do you mean exactly by "condense" columns A to AZ? Do you want to merge them into one row? Or you want to print all the columns one one page?

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

Merging several rows into one row will delete data in all the rows except the first one. If you want to see all the data at one time,then you have to zoom out the window so that all rows are visible on the screen. But if you want the data in all rows to show up in one cell, then you have to create another row and concatenate the data of all the rows. For example, if you have data from B to AZ, create this formula in the column after AZ: =B1&C1&D1....until AZ. This will merge all data in the columns into one cell at the end.

Hope this is what you wanted.

I will give that a try