Large data set with Identifying Name of Report Only Showing One Time

[pick44]

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

[Bo_Ry]

Please try at
E4
=IF(B4="","",LOOKUP("z",A$3:A4))
F4:G4
=IF(B4="","",B4)

Drag E4:G4 down