How to drop down the excle table and automatically change it according to the existing content.
I don't know what is the neighborhood where you live in Jincheng Road, Hangzhou? Suppose it is B2, select this column, and then press CTRL+G to locate the condition, null value and OK. Then you can see that all the spaces are selected, and enter =B2 on the keyboard. At this time, you should be able to see that there is one more under Jincheng Road in Hangzhou. Press CTRL+D again, and it will be filled in automatically.