I'm not qute sure what you are asking for;
but try selecting the second column then put your pointer over part of the
border of your selection, then press and hold the left mouse button and drag
the selection down to the bottom of the first list in the first column. Now
you have one big list, then apply an auto filter using Data|Filter|Auto
Filter, press the drop down arrow and select acsending order?

"arsovat" wrote:

i have two columns with the range of numbers
like
12 23
24 35
36 47
i need to brake each row so it will be
12
13
14
PLS Help