Adding Lines based on Text in a Cell

Is there a way to create a macro to add a new line based off of a certain text in a cell?

Per my screenshot below I want to add a new line every time the state changes. I am thinking we can key off of the first 3 characters in the cell. For example, the first line would be inserted just above the first FL cell. So if the macro can key off of "EFL" that will be very helpful. I do not want to include the numbers in the macro because the numbers behind the first 3 characters change weekly, but the states do not. Also, I cannot write a macro based on row number as new rows get added weekly. Which is why I want to base the addition of a new line on the characters in the cell.

I highlighted in yellow where I want to add new lines. The second screenshot is how I want the final product to look like.

This is a subset of my data, so creating this will save me a lot of time!

Also, I am a beginner at writing macros, so any explanation of what you wrote will help in case I need to edit later or drop in with another macro. Thank you!


Capture.JPG Capture2.JPG