Hello, everyone. This may be a silly question. I have a data in excel 2010.
Column A Column B
Position Value
1 200
5 10
18 20
..........

How can I renumber positions by inlcuding blanks like:
Column A Column B
Position Value
1 200
2 0
3 0
4 0
5 10
.........

Thanks