Merging fields

295
2
02-04-2019 02:04 AM
AnnahNdeketeya
New Contributor II

I have a shapefile with different fields which  i want to use in a model. The challenge I'm facing is the fields I'm interested in are separated and I'm failing to see how i can bring them under the same column. for instance - I'm interested in Household income - yet there are different ranges from none, 1- 500, 500- 1000 etc and these ranges are presented as separate columns(fields) in the attribute table. Yet when I want t convert to raster- feature/polygon to raster tool I have to select one field which now becomes tricky. I hope it's clear enough and someone can assist. 

0 Kudos
2 Replies
RobertBorchert
Frequent Contributor III

Create a new column then use field calculator to populate it from your filled fields. 

0 Kudos
AnnahNdeketeya
New Contributor II

I tried that following this tutorial How To: Concatenate fields in a table in ArcMap  but it doesn't work out. What I need is to have 1 field with 1 figure per row/column representing different household income classes. For example, that's part of the table: so instead of having these columns I want them under one column in different rows.

0 Kudos