formula : reference column cells into rows

  • Thread starter Thread starter scott_01
  • Start date Start date
S

scott_01

Hi, I'm trying to develop a formula that references data stored in
column, A1:A100 (Sheet 1) and to transform it into a row on a separat
sheet from A1:?1 (Sheet 2).

Say in cell A1 (Sheet 2), enter =Sheet 1!$A1
in cell B1 (Sheet 2), enter =Sheet 1!$A2
etc for the 100 cells with out manually changing each entry,

Preference is to develop a formula inplace of a pivot table.

Any help most appreciated
cheers
scot
 
Hi Scott
enter the following in cell A1 on your second sheet:
=OFFSET('sheet1'!$A$1,COLUMN()-1),0)
and copy to the right
 
Back
Top