Google-sheets – Google sheets copy column function to rows

google sheets

What I need is a function to copy from an entire row into a single column.

=a1
=b1
=c1
=d1

and not what I currently get…

=a1
=a2
=a3
=a4

Best Answer

With the limited information you provided, I think you might be looking for the TRANSPOSE function.

Q2:

   = TRANSPOSE(R1:Z1)