Automatically inserting rows
Hello all,
I have a group of data in a worksheet. Is there a formula that I can use to
insert a blank row that separate data that are alike?
Here's my sample data:
PO/NO Quantity
1. 6135008885 10500
2. 6135008885 4284
3. 6135008885 3896
4. 6135008886 4320
5. 6135008886 3780
6. 6135008886 10500
7. 6135008887 10500
8. 6135008887 4032
9. 6135008887 3868
How can I insert a blank row between row's 3 and 4 and row's 6 and 7?
Help appreciated.
Cheers,
Wendy
|