S
swchee
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
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