How do I organize this data properly?

I must preface this post with the fact that I am an amateur using excel. Im trying to learn, but I still dont know what I dont know.

I am manually creating a spreadsheet that tracks certain things that are important to me in regard to my crew. I am a fire captain and I am surprised that the 'insights' of the software we use to document emergency responses does not track specific units chute times. It only calculates the first unit that responds chute time. Most of the time we will have 2-3 units respond on calls, I want to know the chute times of each unit.

I also want to know how frequently we go to certain addresses and the types of calls we go on.

Where I need help is I have multiple rows in my data table that refer to the same call because of the different units that respond. I dont know how to count unique case numbers or the amount of times we went to an address with different case numbers. See the screenshot, I hope I am explaining correctly.

I am open to feedback on arranging this data differently to make more sense.

Just a snippet of the data