Take data from a row in and put it into a column

[Kesbutler]

I want to take data from a row on one worksheet and pu it into a column on
another worksheet. What is the fastest way to do this?

I want row 1 from below to be column A on another sheet.

Example:
A B C D
1 x x x x
2 z z z z
3
4

 

[JE McGimpsey]

I want to take data from a row on one worksheet and pu it into a column on
another worksheet. What is the fastest way to do this?

I want row 1 from below to be column A on another sheet.

Example:
A B C D
1 x x x x
2 z z z z
3
4

One way:

1) Select the cells in row 1.
2) Copy the cells (CMD-c)
3) Switch to the other worksheet and select cell A1.
4) Choose Edit/Paste Special, checking the Transpose checkbox. Click OK.

 

[Kesbutler]

This will work short term but is there something that will auto fill it for
me as the data will continue to grow?

 

[JE McGimpsey]

This will work short term but is there something that will auto fill it for
me as the data will continue to grow?

It's always best to ask your real question first...

In your second sheet, enter:

A1: =INDEX(Sheet1!$1:$1,ROW())

copy down. This will give you zeros where there's no data in sheet1, in
which case you can format the cells to hide zero values.

Alternatively:

A1: =IF(INDEX(Sheet1!$1:$1,ROW())="","",INDEX(Sheet1!$1:$1,ROW()))