To link and Transpose from row to column.

Assumes sheet1 data is in A1:G1

In A1 of sheet2 enter =INDEX(Sheet1!$1:$1,ROWS($1:1))

Drag/copy down to A7


Gord Dibben MS Excel MVP



On Tue, 15 Dec 2009 20:35:01 -0800 (PST), CF wrote:

I have a row of cells with brand names. I want to copy the contents of
the row of cells to a column on another sheet. How can I achieve this
so that whenever I change a cell value on the row I also modify the
value of the cells in the column in question? I was shown how to do
this once, a long time ago, but I have forgotten. I think it involved
the Vlookup function but I am not positive about it.

Thanks...Carlos