It seems to work when you insert the row before pasting transposed values, so try that first.