jmckeone
Well-known Member
- Joined
- Jun 3, 2006
- Messages
- 550
I have a weekly report I work on and to this point I've had to do this manually. Let's say that A1 has a header and below that are the names of states with duplicates having been sorted to fall together so that it would look like the following:
State
Virginia
Virginia
Virginia
Washinton
Washinton
Washington
Wyoming
Wyoming
I would like to be able to insert a row above each new item in column A. In other words at each change in value such that the end result would be like this:
State
Virginia
Virginia
Virginia
Washinton
Washinton
Washington
Wyoming
Wyoming
______________________
Any ideas?
State
Virginia
Virginia
Virginia
Washinton
Washinton
Washington
Wyoming
Wyoming
I would like to be able to insert a row above each new item in column A. In other words at each change in value such that the end result would be like this:
State
Virginia
Virginia
Virginia
Washinton
Washinton
Washington
Wyoming
Wyoming
______________________
Any ideas?