How to Compare two rows in Excel Sheet ?

See more:

C#

C#4.0

ASP.NET4

Hi ,
I am having an excel sheet in which i need to compare two adjacent rows ? How to compare it ?
My excel sheet sample is shown below ??

Table Name Column Dype Max precision scale is_nullable Primary Key
employee EmpID int 4 10 0 N N
employee Name var 50 0 0 S N

In this table field (Table Name) has common values "employee" i need to replace it like below


My output should be like this

Table Name Column Dype Max precision scale is_nullable Primary Key
employee EmpID int 4 10 0 N N
***** Name var 50 0 0 S N