I have a 5000+ number list within a spreadsheet made up of 6 digit order
numbers, if an order numbers 'order' contained multiple items then the number
appears x times in the list, once per item.

I want to pivot the data, but need to extract a list of order numbers with
their relevant data from the other columns, at the moment the only way (to
me) seems to be to sort by order number and manually delete the duplicate
occurences. example of data below, actual is 20+ columns wide

246335 14/06/2007 F170656
246341 14/06/2007 F170925
246526 15/06/2007 F170770
246551 15/06/2007 F170785
246620 18/06/2007 F170993
246627 18/06/2007 F171022
246628 18/06/2007 F171023
246637 18/06/2007 F170699
246689 18/06/2007 F170785
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105

ideas?