Select the *entire* datalist and sort it.

The empty rows will be at the bottom.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Leandro Sesarego" wrote in
message ...
Perfect. It worked! Thanks

Last question so I can solve the whole problem:

Now I have the info horizontally but with 3 blank rows between each
record.
How can I delete the blank rows so I can have a standard list?

Thanks Marcelo, I'm in Los Angeles but I'm from Argentina

--
Leo


"Marcelo" wrote:

Hi Lenadro

select B3:D3 for eg

on B3 (with 3 cells selected) type =tranpose(a3:a5)
enter with Ctrl+Shift+Enter not just enter

copy it down jumping 3 rows and after exclude rows as you need

hth
regards from Brazil
Marcelo


"Leandro Sesarego" escreveu:

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