AnsweredAssumed Answered

Data Output Format

Question asked by lewinn on Jul 29, 2019
Latest reply on Jul 30, 2019 by capcarter

Is anyone familiar with wide vs. long format? 

 

Example - I have 10 unique IDs (polygons). I intersect them with another polygon shapefile, and those records that intersect more than one polygon yields more than one row, but with the same unique ID (so I'd have 20 rows instead of 10, for example). Is there a way to get those into another column instead of an extra row?

 

Initial data:

ID       School                            
1.       Ball State University 

Then I intersect with a city shapefile and it comes out like this:

ID       School                                  City 
1.       Ball State University             Muncie
1.       Ball State University             New Castle

I have two records that have the same ID and school, but two different cities. I’d like for it to look like this (all on one line):

ID          School                         City1          City2
1.          Ball State University    Muncie       New Castle

 

Does this make sense? can this be fixed in ArcMap?

Outcomes