link data

  • Thread starter Thread starter alldreams
  • Start date Start date
A

alldreams

is there a way to link data from a row to a colum?

Any help will be appreciated.
 
Hi
If you want a formula to transpose your row data to a column, you can
use the following (assumption: cells A1:X1 is the source and B2:Bx is
the target)
Insert the following in B2
=OFFSET($A$1,0,ROW()-1)
copy down

HTH
Frank
 
Typo:
correct formula in respect to the assumptions to
=OFFSET($A$1,0,ROW()-2)
Frank
 
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

Link an entire Row with a Key Word 1
Omitting blank cells until filled in? 3
Table function 4
Filling Excel forms 1
Segrigation of different datas from one colum 1
How do I get the current date to autofill 4
If and Vlookup 3
countif comparing two columns 4

Back
Top