I have searched but not sure if some of the relevant information is what i need. Here is what I have:

Column titled "site name", each entry is part of a specific floor/grouping (there is normally multiple entries per floor): (Small example)

USA/CA/Pittsburg/--/--
USA/CA/Pittsburg/--/--
USA/CA/Pittsburg/310/1
USA/CA/Pittsburg/310/1
USA/CA/Pittsburg/310/1
USA/CA/Pittsburg/310/1
USA/CA/Pittsburg/361/1
USA/CA/Pittsburg/361/1
USA/CA/Pittsburg/361/1

I need a blank row between the different groupings. First time poster but long time lurker and noob with excel. Thanks in advance for any help it is appreciated.