Dear all,

Please see the following data:

Part no. Loacation Date
637A A1 10-MAY-2004
807K B1 11-MAY-2004
639A B2 12-MAY-2004
807K C1 12-MAY-2004
807K D1 15-MAY-2004


How can I use macro or function to sort the data by part
no. and then insert a row between each different part no
automatically. Like the below result:

Part no. Loacation Date
637A A1 10-MAY-2004

639A B2 12-MAY-2004

807K B1 11-MAY-2004
807K C1 12-MAY-2004
807K D1 15-MAY-2004