How to Copy data from a row to a column

[Stefan]

I trying to copy info from sheet 1 to sheet 2, the data in sheet 1 is in a
row and I wishes to copy it to a column.

I´m trying to use the function drag and + 1 for the entire row.

Example

Info in Sheet 1 row A1:X1 copy so that the (Sheet 2) column copy
(Sheet2)A1=(Sheet1)A1, (Sheet1)B1=(Sheet2)A2, (Sheet1)C1=(Sheet2)A3 --
ongoing...

 

[MOHANARANGAN07]

Hi,

after copying required/selected data, go to the cell wherever u desire to
paste, there u go for an option paste special & select transpose in that box,

 

[Stefan]

Actually it didn´t solve the problem -

When I type in Sheet 1 I wish it to copy directly to Sheet 2, therefore
copypaste isn´t the answer.

 

[RagDyeR]

Enter this anywhere you wish, and copy down as needed:

=INDEX(Sheet1!$1:$1,ROWS($1:1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Actually it didn´t solve the problem -

When I type in Sheet 1 I wish it to copy directly to Sheet 2, therefore
copypaste isn´t the answer.