I think you have misunderstood the SORT functionality in Excel. If we include
all 4 columns and do a SORT; Excel retains the data in a row. For example
your Row 1 is X1-10-X2-2 . After the SORT suppose this moves to the 5th Row
still the data in the 5th row will be X1-10-X2-2.

To understand SORT please refer
http://www.contextures.com/xlSort01.html

Now for your query; could you please let us know what you are looking for
once you match the data in col C (eg: X2) and place it to the side of the
first instance of X2 in colA..


If this post helps click Yes
---------------
Jacob Skaria


"osaka78" wrote:

I have the following Data
A B C D
1 X1 10 X2 2
2 X1 15 X3 5
3 X2 5
4 X2 6
5 X3 11
6 X3 17
i need to sort them to look like
A B C D
1 X1 10
2 X1 15
3 X2 5 X2 2
4 X2 6
5 X3 11 X3 5
6 X3 17

My file contain more then 10,000 line