Sorting Help
 

Hi: This is my data. Can any one please tell me how to i sort it so
that the codes which have no any value will be go bottom

Raw Data
Code Name Address
1 dd ff
2
3
4 ss gg

Output required
Code Name Address
1 dd ff
4 ss gg
2
3

Thanks.

Sorting Help
 

I just put my cursor on the dd cell and hit sort Ascending and it gave
me the results you are looking for.



On Dec 19, 2:40 pm, "Anna" wrote:
Hi: This is my data. Can any one please tell me how to i sort it so
that the codes which have no any value will be go bottom

Raw Data
Code Name Address
1 dd ff
2
3
4 ss gg

Output required
Code Name Address
1 dd ff
4 ss gg
2
3

Thanks.