How do Excel tables insert blank lines according to the number of shoe codes?

The table is redesigned, and the original table needs to be sorted. The first thing to do is to insert rows based on the number of shoe yards so that the next step is to use them as a unique value in the shoe base (this is the basics of table design--people who know access should know). Then if you do not understand a little Excel skills, using a look at the number of C shoe code, the heart Moji inserted a few lines of approach. For a table that is going to insert thousands of rows, this is a very laborious and time-consuming task. How to insert quickly?

Step One:

1. In order to separate the shoes with different shoe sizes, we need to insert blank lines. The number of empty rows inserted is determined by the number of shoe yards. To facilitate the reader's understanding, I write the title "Number of shoe yards" in the I1, write the formula =len (C2)-len (Substitute (C2, ".", "")) +1, right-click the small black cross in the lower-right corner of the cell, or fill the formula down to the last line in I2.

Description: This formula means the total number of characters, minus null instead of "." After the number of text, get the number of shoe code. C2 is the shoe code (the original table title "code number") LEN returns the number of characters in the text string. The role of substitute is to replace old_text (old text) with new_text (new text) in a text string.

2. Use auxiliary columns: Enter the title "secondary column" in the J1. Enter 1 in the J2 and enter the formula =j2+i2 in the J3. Then right-click the small black cross in the lower-right corner of the cell, or fill the formula down to the last line with the data (item number column).

Description: J2 is the number of shoe code for the corresponding item number calculated in the above steps.

3, fill the serial number, for the next order after the insertion of empty line established standards. At the bottom of the table's secondary column, enter the number 1 in the last blank row, and then fill the number down. The number of rows filled is larger than the value computed by the bottom cell of the J-column (secondary column).

(For those who don't see the Last post, explain again: The shoe code for the same item is on one line, and the goal of our redesign table is to divide them in each row and fill in the adjacent line with the item number.) So you want to insert a blank line. )