Printable View
I have a long list of data output that contains city names and information about those cities across a row. I would like to put a blank row in between city names when a change in city names occurs in a list; thus grouping together rows that have the same city name. I was using a Case statement but i don't know if I'm making it too difficult. PLEASE help. I can attach my raw data if needed.
Excel itself has a subtotal function that sounds like what you might need?
Try Data-->Subtotals, and see if that does what you need it to do?
Unfortunetly that option doesn't work because I need a blank row in between any change in City names. The Subtotal option can only create a page break, and the I do not need to incorporate any funtions like Sum, etc. Any more ideas....?