0
My data in excel has for example the following data in columns A and B:
A B
1 4
2 6
5 88
9 67
12 45
and so on.
I would like to transform it as following:
A B
1 4
2 6
3 0
4 0
5 88
6 0
7 0
8 0
9 67
10 0
11 0
12 45
and so on.
What I want is to insert missing consecutive values on column A values with corresponding column B values as zeros in data.
1This can be done with vba – Dave – 2015-09-16T15:25:31.257