Hi!

Suppose your data is in the range A1:E3 and looks like this:

1;2;3;4;5
2;3;4;5;6
3;4;5;6;7

And you want:

3;4;5;6;7
2;3;4;5;6
1;2;3;4;5

=INDEX($A$1:$E$3,3+1-ROWS($1:1),COLUMNS($A:A))

Copy across then down.

Biff

"via135" wrote in
message ...

hi!

how can i make the data, say, in the first 3 rows
gets inverted..may be in another area of the sheet.?

hlp pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539557