Data Sortin Problem

[Dado]

Hello,

In case of sorting large data alphabetically, once I do sorting function of
data by name in column A it creates two sorted lists, for example 100 names,
it sorts 20 from A to Z and than remaining 80 names AGAIN from A to Z. I
can’t get it sort the entire document in one list. Please help and thank you
in advance!!

 

[YESHWANT]

look out for the cells that may be starting with a space.
On the first line of A column. In some othe rcolumn, type
=trim(a)
then index on this new column and see the difference.
if it works perfect, then rest assured that some your data contains a blank
in the beginning of the data.

click yes below, if it works