Hi,
I've been trying to find a efficient solution to the following problem.
In column A there are several strings:
A || B || C
#Canada 2453 ||
#Chinaabce ||
#Wood 8673 ||
#Carslkus ||
In another table there are the some classifications,for example:
A1 || B1 || C1
Canada|| Country|| America
Wood || Product|| Utility
China || Country|| Asia
Cars|| Product|| Lifestyle
Now my problem is to get the classification of B1 and C1 into the original table (B and C), so that my table looks like:
A || B || C
#Canada 2453 || Country|| America
#Chinaabce || Country|| Asia
#Wood 8673 || Product ||Utility
#Carslkus || Product|| Lifestyle
Does anybody know a efficient way to do this?
Thank you very much!
Bookmarks