Excel Pivot Table

LindseyWinn — Sat, 27 Jul 2019 21:39:50 GMT

Are there any Excel pivot table experts out there? Example:

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

I assume I need to use a pivot table, but can’t figure out how to get it onto the second column.

You win if you can tell me how to do this!

Re: Excel Pivot Table

curtvprice — Tue, 06 Aug 2019 15:59:56 GMT

In Excel insert pivot table with this table of data and use ID and School as Row variables and City as a column variable. Note there is a Pivot Table tool in ArcGIS that isn't as flexible as the Excel functionality but may be helpful to you inside the ArcGIS environment.

topic Re: Excel Pivot Table in Data Management Questions

Excel Pivot Table

Re: Excel Pivot Table