View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leandro Sesarego Leandro Sesarego is offline
external usenet poster
 
Posts: 5
Default Turn vertical data to horizontal data automaticaly

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