How to Add custom Excel column values in Excel file based on conditional contents?

Dear all

i have a large Excel file involve (1000+) countries and their states and variables ... i need to to add column in the last called (label) which involve numeric values based on column A content .. for example if column A include UK then, the values of label column is (1) for all UK rows ... and label value is (2) for all USA rows...and so on for others..

Country-name(A1)      State-name(B1)      ..... variables names....   (Lables)
  UK                    WSG               ....values ..............         1
  USA                   FLO               .........................         2
  UK                    SLE               .........................         1
  PLG                   SEO               .........................         3
  etc..                etc..

So kindly is this possible to be implement in matlab? thanks

Answer 1

[Andrei Bobrov]

T = readtable('yourdataexcel.xlsx');
[~,~,c] = unique(T(:,1),'stable');
Tout = [T,table(c,'Variablenames',{'Label'})];