I have a table with city names, zip codes, county names, and sales tax % for Ohio that I need modified. For all but (10) cities, I've split things up so that it looks like this:
Westerville 43081 Delaware 7.50
Westerville 43082 Delaware 7.50
Westerville 43081 Franklin 7.50
Westerville 43082 Franklin 7.50
West Unity 43570 Williams 7.25
West Union 45693 Adams 7.25
West Salem 44287 Wayne 6.50
Note how Westerville is duplicated (4) times because it has (4) different zip codes while the others are one line each.
For the (10) cities I mentioned at first, Columbus, for example, it currently looks like this:
Columbus 43201 thru 43299 Franklin 7.50
How do I easily insert (97) blank lines ? I know you can select 'x' cells and then use the 'Insert' function to insert 'x' rows and for 2, 3, 5 rows, that's feasible. For (97), not so much. I can transpose the data if I can get past this.