[Solved] Copy rows to columns on different sheets

[Jeff33770]

I need the syntax to copy rows to columns on different sheets. This is what I have =Sheet2!C37 how do I enter the column range?

 

[Lutfor Rahman Shimanto]

I need the syntax to copy rows to columns on different sheets. This is what I have =Sheet2!C37 how do I enter the column range?

Hello Jeff33770

Welcome to ExcelDemy Forum! We thank you for posting your query with such clarity. You want to copy rows from one sheet to columns on another sheet. In this case, you can use the TRANSPOSE function in Excel.

Assume you have a dataset consisting of four columns titled Name, Age, Gender, City in Sheet1. You want to copy rows of column B into Sheet2.

​

Choose cell B2 >> insert the following formula >> hit Enter.

=TRANSPOSE(Sheet1!B2:B5)

​

Likewise, you can also perform transposing throughout C, D and E columns.

​

I recommend you review some articles that may help you with various formula syntaxes for copying rows.

• How to Convert Multiple Rows to Columns in Excel
• Excel Formula to Copy Cell Value from Another Sheet

I am attaching the solution workbook for better understanding. Good luck!

Regards
Lutfor Rahman Shimanto