Hello Dear Friends,
I have 16 types of Landuse parcel attributes which I wish to Classify into Residential, Non Residential and Other category (3 Categories).
Eg. PublicSpace: Non Residential
Commercial : Non Residential
Public Transport: Other
Residential: Residential
Its hard to do manually for list of 225 rows.
Is there some code using IF statement which says if Landuse code is Publicspace, commerical then assign value as non residential in next column, if code is Public transport then assign it as Other, if code is Residential then, assign it as Residential.
Please find attached excel sheet.
Bookmarks