text data consolidation

  • Thread starter Thread starter araki
  • Start date Start date
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
 
Hi
maybe in a helper column a VLOOKUP formula referencing a lookup table
with your conversion information
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
Text function MID, RIGHT, LEN 11
How do I consolidate 2 tables into 1 pivot report? 2
How do I consolidate data into ranges 8
Getting Text data using the Data - Subtotal feature 1
Consolidate work sheets 1
consolidate data 2

Back
Top