Row data into Columns

[jshanoo]

Hi
i have data in
10
11
12
13
14
15
in continous cells in excel, i want cut & copy this in columns
like
10 11 12 13 14 15

can any one help me in this

Regards
John philip *** Even the Best, did the Bad and Made the Best ***

John Philip
Software Programmer
JustDial Services, Mumbai
johnphilip@justdial.com

 

[xlbo]

Copy
Paste Special
Choose VALUES, tick TRANSPOSE
Hit OK
et voila Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes

 

[jshanoo]

Thank Geoff,

but i need it in relative way,

like if i make changes in rows, same should be there in column also

*** Even the Best, did the Bad and Made the Best ***

John Philip
Software Programmer
JustDial Services, Mumbai
johnphilip@justdial.com

 

[joerd]

check out

http://www.cpearson.com/excel/lists.htm

or you may consider the TRANSPOSE function

(quoting David McRitchie)
See HELP for use of the TRANSPOSE Worksheet Function, so that you can change data on the first sheet later and be reflected in the other sheet.
It will be tricky as it must be entered as an array function and you have to know the area to use.

Sheet2, select cells A1:B3
on formula line enter: =TRANSPOSE(
on Sheet1 select cells: A1:C3
you will see formula now reads =TRANSPOSE(Sheet1!A1:C2)
enter from either Sheet2 or Sheet1 with: Ctrl+Shift+Enter
you will now see the formula as an array formula:
{=TRANSPOSE(Sheet1!A1:C2)}
the curly braces denote an array formula and have been included when you used Ctrl+Shift+Enter

You can change values on Sheet1, but if you insert or delete lines in Sheet1 your will mess up sheet2. You cannot change part of your array on sheet2, you can delete the entire array..
Regards,

Joerd

 

[xlbo]

Not sure I understand you
If you are asking for what I think you are asking, it is nothing to do with cut & copy - you need formulae
If your data starts in Sheet1 A1
Then in Sheet2, A1, enter
=INDIRECT("Sheet1!$A" & COLUMN())
and drag it across

Any changes you make to the columnar data will be reflected in the row data
Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes