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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks