how do I super-quickly link a row in one sheet to the corresponding column in
another sheet (without having to do it manually)?

I create a transposed array, but then cannot copy it down... dont know if
this is the best?