Removing duplicate rows; only showing the first row that contains a value

[Uganda]

I have a file with many rows of data and I only need to pick one row for each account number, how do I remove the duplicate rows (I basically want to pick the first row where the account number appears and remove the ones that follow). A snapshot of the data is below, I would basically only want to have two rows in this example; one for 1703 and another for 1739.

[TABLE="class: grid, width: 212"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]1703
[/TD]
[TD="align: center"]93271.59
[/TD]
[TD="align: right"]31/05/2015
[/TD]
[/TR]
[TR]
[TD]1703[/TD]
[TD="align: center"]93271.59[/TD]
[TD="align: right"]31/05/2015
[/TD]
[/TR]
[TR]
[TD]1703[/TD]
[TD="align: center"]93271.59[/TD]
[TD="align: right"]31/05/2015[/TD]
[/TR]
[TR]
[TD]1703[/TD]
[TD="align: center"]93271.59[/TD]
[TD="align: right"]31/05/2015
[/TD]
[/TR]
[TR]
[TD]1739[/TD]
[TD="align: center"]140053[/TD]
[TD="align: right"]31/05/2015[/TD]
[/TR]
[TR]
[TD]1739[/TD]
[TD="align: center"]140053[/TD]
[TD="align: right"]31/05/2015[/TD]
[/TR]
[TR]
[TD]1739[/TD]
[TD="align: center"]140053[/TD]
[TD="align: right"]31/05/2015[/TD]
[/TR]
[TR]
[TD]1739[/TD]
[TD="align: center"]140053[/TD]
[TD="align: right"]31/05/2015[/TD]
[/TR]
[TR]
[TD]1739[/TD]
[TD="align: center"]140053[/TD]
[TD="align: right"]31/05/2015[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance

 

[JoeMo]

If you are using Excel 2007 or a later version, look at Remove Duplicates on the Data Tab (Data>Data Tools> Remove Duplicates).

 

[kalak]

If you are using Excel 2007 or a later version, look at Remove Duplicates on the Data Tab (Data>Data Tools> Remove Duplicates).

Suppose you use first 6 rows of a couple of columns as follows:

Type in 4 10 10b 4 10 4 (space separated values) from A1 down
and
Type in a 10 4 4 10 a from B1 down


Looks to me like there's some duplicate rows on the sheet.
How would you remove them?

 

[kalak]

er .... bump