I am trying to use the Spaghetti and Meatballs overlay technique to create a fire history layer from Cal Fire FRAP's fire perimeter data. I am following the technique Dale Honeycutt describes in his ESRI blog post. However, at the spatial join part, instead of doing a one to one join, I am performing a one to many join. This then gives me multiple points with the same "Target FID" value, but different values for Name and Year of Fire. His next blog then goes into detail on how to combine the points with repeating "Target FID" values into one point with a string of values for both the Name and Year of Fire columns. However, that blog seems to no longer exist.
Essentially what I am trying to do is take data that looks like this:
Target_FID Fire_Name Fire_Year 2 Otay 1953 2 Wheeler 1989 2 Thomas 2017
To look like this:
Target_FID Fire_Name Fire_Year 2 Otay_Wheeler_Thomas 1953_1989_2017