Excel Column Help

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

Are these Incident number entered manually or is this data what you you already have? Do you need them to be merged like in the examples?

I have all the incident numbers in the data base they sent to me. I do not need to enter them manually. I just need to make them look like my sample. Thanks

Maybe something like this

PHP Code: 

=UNIQUE(IF(H1:H16<>"",H1:L16),FALSE,TRUE) 


I think I misread your question. The H1:h16 were manually put in by me. The A1:F16 is the data I need to become like your formula shows.

Thank you, will look it over