Excel Column Help

[pick44]

I have listing of crime data that is in a format that I cannot easily convert. I have attached the original sample and a sample of what I need to have.

If an "Incident Number" is shown in a cell then the data in the rows is needed. You will see a couple of cells like J 6-7, and J 15-16 that have only one Incident number but the address shown twice. I only need an address once when incident numbers are same even though the row may be like j 6-7....I would only need the address once as in L 6.

Office 365, Windows 10

Thanks