nick wrote:
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 he
http://www.cpearson.com/Excel/Duplicates.aspx