Turn vertical data to horizontal data automaticaly
Hi,
I have data(500 companies) that looks like this;
business name.
Address.
phone
business name.
Address.
phone
and I wat to convert it to this; (automatically)
business name,Address,phone
business name,Address,phone
can any one tell me how ?
thanks in advance
--
robw150956
God Bless
"Leandro Sesarego" wrote:
I have a big amount of records that looks like this:
Leo Sesa
10666 Wilkins Ave #306
310-494-5875
Paul Wakki
12510 Van Nuys Blvd
818-497-9552
Is it possible to make that info "horizontal", like this? :
Leo Sesa 10666 Wilkins Ave #306 310-494-5875
Paul Wakki 12510 Van Nuys Blvd 818-497-9552
I mean, I know how to drag and drop every cell one by one, but I'm looking
for something automatic since I have a lot of data.
Thanks a lot !
--
Leo
|