Linking cells between worksheet - from column to row

D

DM

Trying to copy range of data (down) from a column in worksheet A and link it
in a row (across) in worksheet B. Link won't work in a range of data and
transpose isn't working (or I'm not doing something right.
 
M

Max

Assuming source data in sheet: A,
data running in A1 down

In sheet: B,
Place in any start cell, say, in B2:
=INDEX(A!$A:$A,COLUMNS($A:A))
Copy B2 across as required to return the dynamic transpose
of the source data in "A"
 
T

Teethless mama

Copy your range in worksheet A. Select a cell on worksheet B , right click,
Paste Special , Traspose, click OK
 
Top