traspose a row by links

  • Thread starter Stan Altshuller
  • Start date
S

Stan Altshuller

Hi all,

When one tries to past links, the transpose button is grayed out.
I have a column of integers 1:n going down column A starting A2


i need C1: CN to be exactly the transpose of the column A. I tried using
offset and it does not do what I want,
by putting C1=OFFSET($A3,C1,0) i get it only if the numbers are in order.
If i change a number in A:A it messes up the sequence.
Thanks!
 
N

N Harkawat

On cell B1 type
=OFFSET($A$1,COLUMN(),0) and copy it across the row 1
assuming that the your data source begins from cell A3
 

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

Traspose Column data into Row 3
Macro to traspose cell values 1
Eliminate blanks while copy row and transpose 11
Combining two formulas 0
Linking cell ranges between rows and columns 1
Column To Rows 3
Find values of a column in another and paste range of rows 1
Transpose link 5

Top