Converting Columns to Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
#REF! 1
convert columns to rows 6
Excel Help to copy information from one row at a time to another sheet 1
Voltage supply issue related to NUC PC Core i7 0
using row number or column letters in formula 5
Finding identical rows in a list 6
Excel Subtracting multiple columns from another column 3

Back
Top