transpose

  • Thread starter Thread starter briank
  • Start date Start date
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?
 
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.
 
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 =
 
Back
Top