do you mean across lots of work books or all on the same sheet?
Thank you for your response. Is their away to do that same "Transpose" for hundreds of sets of data the same way?