Try this.

Say your datalist is on Sheet2, from A1 to X30.

You can enter this formula *anywhere* on Sheet1,
then drag across to copy as many columns as needed.

Then, while the row is *still* selected from that first copy,
click on the fill handle of that selection, and drag down to copy as many
rows as needed.

=INDEX(Sheet2!$A$1:$X$30,COLUMNS(Sheet2!$A:B),ROWS (Sheet2!$1:1))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Kaziglu Bey"
wrote in message
...

Appreciate your efforts anyways.:)

Scott Wrote:
I see what you're trying to do and now I know why you want to do it but
for
the life of me I dont have a solution right now. My only suggestion is
to
copy the section you want out of the Serial Page and do a PASTE SPECIAL
then
choose TRANSPOSE and this will put the data in the format you want,
however,
it wont update automattically because it is just a copy of the data and
not a
formula. Sorry, hope someone else can help.


--
Kaziglu Bey
------------------------------------------------------------------------
Kaziglu Bey's Profile:
http://www.excelforum.com/member.php...o&userid=36086
View this thread: http://www.excelforum.com/showthread...hreadid=558691