Hi, I need help with my data. I have numbers going from 0 to 9999 on column C, and have data corresponding to those numbers on column D. The problem is, a lot of numbers in column C is missing, and i need to fill in those numbers and have 0s in column D.
Sorry if this is confusing, I'll explain below-
What I have:
0 142
1 524
2 918
3 123
5 421
6 516
8 345

What I need:
0 142
1 524
2 918
3 123
4 0
5 421
6 516
7 0
8 345

So the missing counts from column C need to be put back in with a value of 0 in column D.
I tried edit-fill-series to make fill in the missing numbers in column C, but I can't do it for column D.