Hi Guys,
I have posted a request and recieved an answer but it does not do what I
require although it does exactly what I asked :-(

I'll try and re-phrase

I have 5 cells per day
Mon B1:B5
Tues B6:B10
Wed B11:B15 etc etc.

Now on Monday I might only complete 2 jobs and Tuesday I might only complete
1 job and Wednesday I may complete 4 jobs, thus utilising cells
B1,B2,B6,B11,B12,B13,B14

Now I have to fill out another part of the spreadsheet E75:E100 with the
info in cells B1:B25 but with no spaces except one space between days

so E75,E76 would contain mondays stuff
E78 Tuesdays
E80,E81,E82,E83 Wednesday etc

But because jobs completed in anyone day varies between 1 and 5 i'm not sure
what I need to do.

many thanks in advance and thanks to DMEXCEL for the rapid response.

Hopefully this is clearer

Keith