I am trying to create a table of wetland types per road segment with a field containing concatenation of unique IDs of each wetland type. The source table looks like this:
I would like a result that looks something like this:
I have tried to dissolve based on segment and wetland type and then conduct a spatial join to concatenate the UID field but have failed to achieve the desired table. Something is wrong with my process and I am struggling to figure it out.