Help converting table of data into new layout

[PFDave]

Hi,

I can't really explain enough in the subject so here's hoping I get the right audience

I run an SQL query, I export this to Excel which gives me a list of different locations in column A and then the start and end hours of those locations in Columns B through O

What I require as an output is on Desired Output sheet.

I want to know the start and end hours for each different day, and then from that I want to establish which of those days is BDH (late opening) by looking at the average start time only including M-F.

The range will be ever changing so the number of locations changes when new ones are created.

Could anyone offer some help on this please?

I use the below code to create 7 values of each entry in column A of sheet 1, but I can't work out what to do to continue the process for the other fields as they are not simply drag down formulae.

Please Login or Register  to view this content.

Thanks in advance

[Olly]

Try:

Please Login or Register  to view this content.

That will add a new worksheet, containing your required output.

[mike7952]

Another solution

Please Login or Register  to view this content.

[PFDave]

Thank you both for your great solutions. Both fit for purpose and I really do appreciate your help on this.

Thanks again

Dave