oh groan...
cross post where already answered:
changing arrangement of data to new style [SOLVED]

saied, please have a read of Excelguru Help Site - A message to forum cross posters
I feel I've wasted my time.