Forum Discussion
Transpose Multiple Rows
Hi, I am trying to transpose a large amount of data. My problem is below. I am trying to transpose columns G-J...so I do the following {=transpose(G10:J10)} which works exactly how I want it to...
Don't really understand what range of cells you want to transpose. If, e.g. the range is G10:J20 you can simply select a destination cell and enter =TRANSPOSE(G10:J20). Just make sure that the resulting output does not overlap the initial range, because then you will get a #SPILL error.