Excel Fill down on sheet2 for rows in sheet1

Use a TRANSPOSE formula on Sheet2 that points to the row on Sheet1.

Example:

1. Suppose the data is in Sheet1, row 2, from A2 to F2.
2. Go to Sheet2 and select a vertical range with the same number of cells (e.g., A1:A6).
3. Type this formula:

      =TRANSPOSE(Sheet1!A2:F2)
   

4. Confirm as an array formula:
   • In current Excel: press Enter (dynamic arrays will spill automatically), or
   • In older Excel: press Ctrl+Shift+Enter.

Sheet2 will now show the row from Sheet1 as a column, and it will update automatically when the data on Sheet1 changes. Use fill/Auto Fill on Sheet2 to repeat this pattern for other rows by adjusting the row reference (e.g., A3:F3, A4:F4, etc.).

References:

• Fill data automatically in worksheet cells
• Enter a series of numbers, dates, or other items