I was beginning to think that my post hadn't been posted..
Apologies for posting external link, I have created an image of it instead.
I hope that this helps give the example ? am still struggling to work out how I can do this
Maybe I should add I have been working on this from other sources of data and the row at the top is generated from an Index function itself so that if any of the source data from other locations change so will the data here, which I then want to automatically be sorted into the rows. from this I am going to be putting into another sheet so that the statistics and data can be tidied up. this is the final part of the hurdle that I just cannot figure out myself.
Thanks again for any help.