Hi JJJ,

When I transpose the paste link button greys out. Can I transpose and
paste the link somehow

No, this why it is greyed out.

You could write a formula with the OFFSET() function, however, this
will not be readable for humans, ie. you'll get a problem when
troubleshouting.

arno