How show single line rather than multiple line with same desc in e

[nick]

How to show single line rather than multiple line with same desc in excel.
What is the steps to remove those repeated info by using excel function.

 

[Gordon]

How to show single line rather than multiple line with same desc in excel.
What is the steps to remove those repeated info by using excel function.

To put this into English - you have duplicated rows of data in an Excel
spreadsheet.

Have a look here:
http://www.cpearson.com/Excel/Duplicates.aspx