The data set is very large and the name of the incident is only showing one time for each cad# which represents the name of the incident. I have attached an excel sample page. The original data set is in columns A thr C and the data set should show as seen in Columns E thr G.
Using Windows 10 and Excel 2016
Bookmarks