Hi,

Assuming that your data is in the following format (nos are in the range
C6:E8)

A B C
Ashish 1 2 3
Sameer 4 5 6
Gautam 7 8 9

You can get data in the following format (transposed data) (nos are in the
range C11:E13)

Ashish Sameer Gautam
A 1 4 7
B 2 5 8
C 3 6 9

The following formula in cell C11 would do the trick

=INDEX($B$5:$E$8,MATCH(C$10,$B$5:$B$8,0),MATCH($B1 1,$B$5:$E$5,0))

Now copy it the range.

Regards,




"SSD1" wrote:

I am collecting data that occurs in columns and want to transpose it to rows.
Can I avoid the "Paste Special/Transpose" route? Is there a way to
automatcially transpose the data every time I paste.

--
SSD1