software

Im trying to drag and copy a list from a sheet.

on one sheet the numbers are listed horizontal, sort of as a chart, and
the toatals are avg. at the bottom. I want to take the avg.ed numbers
and put them into a vertical chart in another sheet.

How can I format the equation to let me do this?

*right now, it automaticly copies the cells down. I.e. A5, A6, etc.--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile: www.excelforum.com/member.php...oamp;userid=28719
View this thread: www.excelforum.com/showthread...hreadid=509428Example:

ABCDEF
1greenbrownredyellow
2green
3brown
4red
5yellow
6
7

select A2:A5

type =transpose(b1:e1) and hit shift-control-enter (it's an array
formula)

That will arrange the horizontal numbers verticlly.

Then copy and edit--gt;paste special--gt;values to your new location

Hans