Merge fields with the same Property Number

[EMM03]

Hi everyone,

I have a corporate land use layer which shows what a property is currently being used for (forestry, agriculture, residential, etc.). However, some properties have multiple uses, like this one.

In the attribute table, it shows the same PID but each row has a different land use.  

Is there a way I can combine the land uses for each PID into one row? For example, for PID 675264, I would like the "LandUse" column would say "For, Wet". I have approximately 3,400 properties and with the multiple land uses, it's approximately 28,000 rows. So I would just like to reduce this to the 3,400 properties (rows), if possible. 

Thanks in advance!

[BobBooth1 · Accepted solution]

You might look at Dissolve, dissolving on PID, with the statistics fields using the CONCATENATE option.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/dissolve.htm

[Bud]

Some people reading this post might be interested in Oracle’s LISTAGG aggregate function. It could be used in a SQL query in a database view or query layer. It’s likely not practical for this use case, but still might be of interest.