excel in case of emergencies!

Now there is a set of data, such as 1,2,3,4 ….I would like to insert in each of the two directly to a 0 to enable him into 1,0,2,0,3,0,4,0, …., So I do not know how to achieve it in excel (the data is an original, and with a one equivalent to an increase of between two per 0, so that only the original 1000 line into the 2000 line), thank you!

with auxiliary out to achieve.
such as this column is A list, find out a space or directly into the B list.A column The number of column B in order to fill ……1, 3, 5, that is filled with odd-numbered.Filled to 1000 and then to fill ……2, 4, 6, that is, behind the A's in the air as to even out B Filled.B and then to sort out.
Row order after deleted End B can be listed.You assume that the data in the column A, B1 enter the formula

= IF (ROW () / 2 = INT ( ROW () / 2), 0, A1)

copy and then paste the entire cell B1 to the B list of other cells.You can (for example, the first column B) out of this 1,2,3,4 The back of an increase (for example, the first column C) assignment, in order to accumulate automatically 1,2,3,4.Then, you set out in section B on the copy of 0 to 1000, in the corresponding C out on assignment for 1.1,2.1,3.1 it also automatically accumulate until 1000.1.C by the end sort out what you want.If the data is in A1:A5, in the column B, enter:1,2,3,4,5, 1.1,2.1,3.1,4.1,5.1, and then ascending symbol (that is on the A and Z under a down arrow), B delete data.A selected list, F5, location, null, editor in the column input 0 At the same time, according to Crtl + Enter on the OK.I have a possible solution, is also relatively simple methods, not feasible unless they view you.You assume that the data are out in the first line of A, B can be out in the B1 input S, B2 enter K, (the importation of any letter does not matter because the two are mainly the same can be a) to select the next B1, B2 copy, Niantie to the B1001, select B1:B1001, CTRL + G Location dialog box appears, location Conditions out there are differences in the election cell, identified on the S contains all the selected cells, right-point line to insert the entire election, you can see that there have been 2 digital space and his party, which completed a two-thirds of One problem, select the next B to B set out in the air as the replacement of all the K value, or the next column B the election constant position, you can select to see all the letters S, insert the entire line, followed by the first line Deleted, it is the effect of each line has a space below the line, followed by a simple, or location, you have to add blank lines inside a 0 on any worksheet in which local input 0, and then to copy, select A1 :A2000, according to the CTRL + G, the election null and then the OK to return.Number of words may be looking at more, in fact, operating with relatively simple.