1st, How can I insert a row each time the data in column A changes?
2nd, How can I number the above rows with consecutive numbers for the first entry only?
Example:
1 abc
abc
abc
2 123
123
123
123
3 bcd
4 234
234
234
234
234
Please help, I have @ 1,300 items with @ 23,000 rows of data to look at.
2nd, How can I number the above rows with consecutive numbers for the first entry only?
Example:
1 abc
abc
abc
2 123
123
123
123
3 bcd
4 234
234
234
234
234
Please help, I have @ 1,300 items with @ 23,000 rows of data to look at.