Re: Paste Special - Values - Transpose


You can also do this using a range like ***!2A1:J15 as your source.
You just need to remember to select the same number of columns for the
rows and rows for your columns in your new list. So you would select
10 rows (A:J in the original data) and 15 columns(1:15 in the original
data) where you want the data transposed. This way it is a one time
deal entering in the formula for the entire range of data. If your
range expands, it is easy to edit.



Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7571
View this thread: http://www.excelforum.com/showthread.php?threadid=491087

.