How to compare two columns in a table and delete that row having same values in that columns?

column1    column 2    columns3
ball       bat         gloves
bat        gloves      bat
ball       gloves      ball

Mow if I compare column1 and column3, I want to remove the rows having same values in that row of the columns

Answer 1

[dpb]

 c=string({'column1'    'column 2'    'columns3'
'ball'       'bat'         'gloves'
'bat'        'gloves'      'bat'
'ball'       'gloves'      'ball'});

c=c(c(:,1)~=c(:,3),:);

returns

>> c
c = 
  2×3 string array
    "column1"    "column 2"    "columns3"
    "ball"       "bat"         "gloves"  
>> 

I kept the header row to have something else in the array as a result...

Answer 2

[Sanwal Zeb]

Hi, I want to do this in tables not in strings.

[dpb]

Well, we'll have to see what you really have to write actual syntax...we can't see your workspace from here...