Converting Columns to Rows

C

Chris D'Onofrio

I am trying to convert/tranpose multiple items in columns to rows. The issue
is the itmes i am moving in the columns are the results from a formula. So I
am getting the REF and not the numbers I am looking for. Any suggestions are
much appreciated.

Chris
 
G

GerryK

Try some modification of this:
Where A2 down contains numbers or formulas that give a
number.
put =OFFSET(Sheet1!$A$3,COLUMN(A:A)-2,0) in B2 and
put =OFFSET(Sheet1!$A$3,COLUMN(B:B)-2,0) in B3 etc.

HTH
 
Top