Columns as Rows

  • Thread starter Thread starter tpsstudent
  • Start date Start date
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
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i transpose a worksheet with formulas and look up tables in 5
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row 2
Transpose Large Column to Row 2
Switch from Columns <-> Rows 5
How to transpose data (Row to column) without losing the cell link 3
Auto Fill formula from a column to row 1
Transpose function 4
Transpose large column 3

Back
Top