Columns as Rows
 

Hi, pretty new excel user and I was looking for a way to view columns as
rows and vice versa without transposing the whole sheet.

I've tried transposing to two different worksheets and then linking but
that process was slow and fraught with errors.

Is there any way to do this easily?
Anyone have any suggestions for lookups on the Excel website or Help,
I've run out of ideas to look up

Thanks


--
tpsstudent
------------------------------------------------------------------------
tpsstudent's Profile: http://www.excelforum.com/member.php...o&userid=36256
View this thread: http://www.excelforum.com/showthread...hreadid=560500

Columns as Rows
 

Excuse my clock!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
Say you want to take Column A, and display it along a row (*any* row),
Enter this in *any* cell, and drag across to copy:

=INDEX($A:$A,COLUMNS($A:A))

Say you want to take Row1, and display it down a column (*any* column),
Enter this in *any* cell, and drag down to copy:

=INDEX($1:$1,ROWS($1:1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"tpsstudent"
wrote in message
...

Hi, pretty new excel user and I was looking for a way to view columns as
rows and vice versa without transposing the whole sheet.

I've tried transposing to two different worksheets and then linking but
that process was slow and fraught with errors.

Is there any way to do this easily?
Anyone have any suggestions for lookups on the Excel website or Help,
I've run out of ideas to look up

Thanks


--
tpsstudent
------------------------------------------------------------------------
tpsstudent's Profile:
http://www.excelforum.com/member.php...o&userid=36256
View this thread:
http://www.excelforum.com/showthread...hreadid=560500

Columns as Rows
 

Say you want to take Column A, and display it along a row (*any* row),
Enter this in *any* cell, and drag across to copy:

=INDEX($A:$A,COLUMNS($A:A))

Say you want to take Row1, and display it down a column (*any* column),
Enter this in *any* cell, and drag down to copy:

=INDEX($1:$1,ROWS($1:1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"tpsstudent" wrote
in message ...

Hi, pretty new excel user and I was looking for a way to view columns as
rows and vice versa without transposing the whole sheet.

I've tried transposing to two different worksheets and then linking but
that process was slow and fraught with errors.

Is there any way to do this easily?
Anyone have any suggestions for lookups on the Excel website or Help,
I've run out of ideas to look up

Thanks


--
tpsstudent
------------------------------------------------------------------------
tpsstudent's Profile:
http://www.excelforum.com/member.php...o&userid=36256
View this thread: http://www.excelforum.com/showthread...hreadid=560500