How do I combine Data to have it as the spreadsheet attached

[CaroleWacta]

Hello, I am doing some spatial analysis to locate the best site for a project. Following the spatial Analyst tutorial (but using my own data)...

I need to get my zoning layer look like the spreadsheet by combining all similar number into a single row as the spreadsheet..

Can anyone help me please.

I am unsure how to tackle that and keep the integrity of the data... In the end, I will have 01 to 09.

Thank you in advance.

Carole

[DarrenWiens2]

This sounds like a job for Dissolve (or Summary Statistics if you're only interested in the attributes, not geometry).

[CaroleWacta]

sorry, I am interested in Both the geometries and attributes...

thank you for the reply

[DarrenWiens2]

Then, dissolve.

[TimOrmsby]

I think you want to use the Dissolve (Data Management) tool and specify a Dissolve Field. This will combine all features that have the same value in the specified field into a single feature. I don't know which field you need to dissolve on--maybe the Zone field?--but you probably know. Note that the output features will be multipart. If you want, you can change that by unchecking the Create multipart features box at the bottom of the Dissolve tool dialog box. Then you'll have more features but each feature will be an undivided piece.

[CaroleWacta]

Tim,

Thank you that sounds good...I want to Dissolve on the CODE field so that all 01 are together and so on..

So should I use the above steps...

I think I will like to keep the data as multipart... Just want them in the same row.

Thank you.

C

[TimOrmsby · Accepted solution]

Yes, if you dissolve on the Code field that should give you what you want. Give it a try...

[CaroleWacta]

thank you...

It worked...

Thank you....

C