How can I move data from a row range to a column range

[Josh W]

I have random data in rows eg. A1 to A20. I want to move all data to columns
A-T as follows: data from A2 to cell B, data from A3 to cell C, data from A4
to cell D, etc. Or vice versa from columns to rows. What is the quickest way
of acheiving this other than the laborous cut and paste of each cell
individually? Many thanks for your help.

 

[T. Valko]

Try this:

Select the range A2:A20
Goto the menu Edit>Copy
Select cell B1
Goto the menu Edit>Paste Special>Transpose>OK
Delete the data in A2:A20

Follow the same technique to go from a row to a column.

 

[Josh W]

Thanks Biff, perfect. I noticed that the paste section must be outside the of
the original selected taste, otherwise you get an error message.

 

[T. Valko]

Yeah, they also don't let you do a cut>transpose, either. That would save
the extra step of having to delete the original data.

Thanks for the feedback!

 

[امجد]

الحقيقة انني لم استطع الاستÙادة من هذه المعلومات لان حاجز اللغة حال دون ذلك
ارجو توÙير الاجابات بشكل يتلائم مع الامكانيات اللغوية لكاÙØ© الاقراد واعتقد
انكم مهتمون بذلك لانكم رواد ايصال المعرÙØ© للجميع بغض النظر عن الانتماءات
المختلÙØ© وتقبلوا تحياتي