pasting a row into a column

[greg7468]

Hello, probably embarrassingly easy to do but my brain hurts now.
I am trying to copy and paste a row of headers so they go down in
column but it will not work. can somebody please point me in th
general direction. Thanks in advance

 

[Don Guillett]

copy>edit>paste special>transpose

 

[Max]

a. For a one-time Tranpose:
Copy > Paste Special > Transpose > OK

b. Another way is to use TRANSPOSE()
(which stays "linked" to the source)

Assume the source range is say in Sheet1, in A11 (a 1R x 4C grid)

You can transpose this to another sheet, say, Sheet2

In Sheet2:
------------
Select say, A1:A4 as the target range
(Target range must be a 4R x 1C grid, the "converse" grid to the source)

Put in the *formula bar*: =TRANSPOSE(Sheet1!A11)

Array-enter the formula, viz.:
Hold down CTRL + SHIFT, press ENTER
(instead of just pressing ENTER)

Done correctly Excel will wrap curly braces around the formula, viz.:
{=TRANSPOSE(Sheet1!A11)}

(don't type-in the curly braces!)

The same formula will appear in each cell in A1:A4

Whatever's showing in Sheet1 A11 will be transposed into Sheet2 A1:A4

If Sheet1 A11 contains for eg: formulae returning values which may
change, then the changes will be correspondingly reflected in Sheet2 A1:A4

 

[greg7468]

Thank you.:

 

[Max]

Pleasure' greg7468 !