Hi all,
I have in column A cells a2:a10 capital cities.what i want to do is instead of having them vertically from a2 to a10,display them horizontically from b2 to k2.
I tried to use =transpose(a2:a10) but got a #value.any help is great.thank you.
Hi all,
I have in column A cells a2:a10 capital cities.what i want to do is instead of having them vertically from a2 to a10,display them horizontically from b2 to k2.
I tried to use =transpose(a2:a10) but got a #value.any help is great.thank you.
Last edited by giant; 08-14-2010 at 09:07 PM.
Copy your data A2:A10
Select Cell B2
Paste Special > Check "Transpose"
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks Marcol,
that seemed very simple.Tell me why does'nt the formula i typed work.
It will work if you select B2:K2 and confirm the formula with Ctrl+Shift+Enter instead of just Enter.
See http://www.cpearson.com/excel/ArrayFormulas.aspx
Entia non sunt multiplicanda sine necessitate
Thanks shg
Its great to learn something new everyday,today i learned 2.
Thanks to you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks