it's not actually something that I don't know how to do. It's just the absolute pain of having to compile data from several excel spreadsheets to do averages. So unless you know a way to make "paste values only" the default for "ctrl v", there's no less pain.

Plus, there never seems to be an easy way to figure out the easiest way to set up the averages..vertically or horizontally. both have their pluses and minuses.

Magic wand for it to do itself maybe?