transpose

B

briank

I have a worksheet A1..BI41 that is filled with links to
another spreadsheet. I want to transpose this worksheet
but Excel does not keep up with the links. Is there a way
to make this work by using the copy/edit/tranpose paste
command?
 
B

briank

The TRANSPOSE function did work but it now creates a link
to a link. Is there anyway to tranpose my linked data
while still keeping the original link?

Thanks.
 
K

Ken Wright

Select your original data and do Edit / Replace, replacing = with %%. Then do Edit / Copy and
then Edit / paste special / transpose to your new area. Now select this data and do Edit /
Replace, replacing %% with =
 
Top