text data consolidation

A

araki

Hi all,
I am working with a data set that has 200 records. I have a colum
(text data) has that about 9 different values. What I want to do i
lump some of them together. e.g. dry/perenial and non-perennial I wan
to place into another column,and label it dry. So I am trying to winno
down the 9 different values to 3 different ones; dry, diversion, an
other. I could just go down the present column and do it manually, bu
there has to be a faster way.
Any help would be good.
TIA,
Rand
 
F

Frank Kabel

Hi
maybe in a helper column a VLOOKUP formula referencing a lookup table
with your conversion information
 
Top