Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |