Summarizing a feature class issue

Discussion created by JLuymes on Jan 5, 2012
Latest reply on Jan 5, 2012 by rfairhur24
I'm trying to summarize a feature class based on a street name by using all the values in another grid field.

For example, here are a few records:

StreetName                GRID
Academy Road            50B
Academy Road            40C
Academy Road            49B

And I would like it to be summarized to:

StreetName               GRID1       GRID2       GRID3
Academy Road           50B          40C          49B

I know the summary statistics can give first and last values in this way, but I'm looking for something that will list all the values in one record. Thanks in advance for the help,