Copy the cells. Move to where you want them pasted. Select the first cell
only. Hit Edit--Paste special--Transpose, OK.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"swchee" wrote in
message ...

Hi, I have this question which need helps :)

How do I arrange a single column of data into vertical arrangement ( or
vice versa)?
Can I do this just using a formula or do I hv to use a macro?


eg of source file: ( all in diff cells)
apple
orange
kiwi fruit
papaya
banana


expected output
apple | orange | kiwi fruit | papaya | banana

Thanks in advance.
Regards


--
swchee
------------------------------------------------------------------------
swchee's Profile:
http://www.excelforum.com/member.php...o&userid=24279
View this thread: http://www.excelforum.com/showthread...hreadid=380427