Columns as Rows

T

tpsstudent

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
 
R

Ragdyer

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))
 
Top