Hoping someone can save me from a tonne of copying and pasting - and maybe a shred of my sanity.
I have over 200 worksheets - separate participants data. On each sheet there is a summary column of data at the moment. I now want those columns of data copied to a summary sheet but transposed to rows.
I have attached an example with 3 worksheets and the sort of summary sheet I am after. Thank you in advance for any help.
Bookmarks