convert vertical to horizontal
Hi,
Say the cell reference of 1 is B5. In cell B10, type B5 (without the =
sign) and with the fill handle drag this to the right. When you do so, you
will get the cell references instead of values. Now select the array and
press Ctrl+H. In the Find box, type b and replacer with =b
Hope this helps.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
"Mona" wrote in message
...
I see lots of post but not one I can use. I am looking for a "function"
that
will take vertical data to horizontal. I don't want the copy,paste,
transpose please.
Example :
1
2
3
Results
1 2 3
thanks!
|