Thread: Grouping rows and copying data

In my spreadsheet I have rows that need to be grouped together to be able to copy a specific column's data. First, How would I group them (automatically) and second, how would I copy the required data.

Example.

1. road number (00101) id (12345)
2. '' (00102) (12345)
3. '' (00103) (needs the same id number)

Then it would go to a new road.
1.(00201)(12344)
2.(00202)
3.(00203)(12344)

I just need a way to be able to group the road numbers to automate and fill in the area's that need id numbers.
There are 87000+ records otherwise I would just do it manually.

bump bump ..