Posted to microsoft.public.excel.newusers
|
|
how do I transpose a row of cells to a column between worksheets?
=INDEX(Sheet1!$1:$1,ROWS($1:1))
Entered in A1 of Sheet2 and copied down column A
Gord Dibben MS Excel MVP
On Thu, 13 Sep 2007 08:08:04 -0700, Mike C <Mike
wrote:
I want to transpose a row of cells (containing a formula) from one worksheet
into a column of cells in another worksheet. How do I do this?
|