transposing col to row maintaining link

B

Bruce

I want to copy a column of data in one sheet to a row of
data in another sheet and maintain the link. Excel allows
either but not both in the paste special dropodown menu
Can anyone help.
Thanks Bruce
 
K

Ken Wright

Are you looking to create another set of data that links back to the range you just transposed; if
so then:-

Use the TRANSPOSE function:- assuming your data is say 2
columns by 5 rows, select a range that is 5 columns by 2 rows and just start
typing =transpose( ,when you get to the open bracket select the data you
are trying to transpose, put in the last bracket and then hit
CTRL-SHIFT+ENTER which will eneter it as an array formula. This will
transpose all your data and keep links to the original.
 

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

Rows columns transpose & link 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
using the =page! feature to transpose a row to column 0
Copy Transpose and Link Data 1
Transpose with Match ? 4
Transpose 2
Copying formulas in Columns and transpose to rows? 5
2 formulas needed same workbook 15

Top