How do I invert an Excel table (collumns become rows)?
 

I am in Excel and need to invert a table so that the collumns will be the
rows and the rows will be the collumns. What is the easiest way to do this?

Thanks!

How do I invert an Excel table (collumns become rows)?
 

Try this function:
=OFFSET($A$1,ROW(A1)+COLUMN(A1)-2,)


Or, simply copy and paste special Values Transpose


Regards,
Ryan--

--
RyGuy


"songstarter" wrote:

I am in Excel and need to invert a table so that the collumns will be the
rows and the rows will be the collumns. What is the easiest way to do this?

Thanks!