Insert a blank row based on the value in a certain column
I am trying to find a macro or add-in that will insert a new row when it finds a change in value in a particular column. In example below, I want to be able to select column A (Team) and have Excel insert a new row when it finds a new value. In this case I'd get a new row under Team and then under 0123.
TEAM SCHOOL STYLE EMBELLISH GARMENT COLOR
0123 PURDUE BAC WDMK BLKOGD
0123 PURDUE BAC WDMK BLKOGD
0143 BAYLOR BAC WDMK HNTGLD
0150 GEORGIA BAC WDMK BLKRED