Hi bob135

Two methods:

1. Create a transposed array
Select your target range & type:
=Transpose(source)
and press Ctrl&Shift + Enter
Note: source = your source range

2. Enter your untransposed formulae as per normal (copying & pasting
over the range). Then change any formulae to text by Ctrl-H and
entering an equals sign = as the find criteria and say $$$$ as the
replacement criteria. Then your table is made of values only and you
can copy and paste-special-transpose. Then reverse the find and
replace exercise to put the equals signs back. Voila - transposed
formulae and values.

Note: The Array formula is more memory intensive, less understood &
less flexible and I prefer the second method.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532136