Excel copy-paste-Skip empty cell case

To merge Table I with table two into table 3.

There are two steps to go, the first step is to populate table 1 with the first column of table 2 complete, the second step is to merge the contents of Table 1 and table 2.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/21/wKiom1Sp5C7yvI39AAGZPUh5Ysk019.jpg "style=" float: none; "title=" 2.jpg "alt=" Wkiom1sp5c7yvi39aagzpuh5ysk019.jpg "/>

The first column of table 2 is fully supplemented. Check table 2, column A, e5:e15. Start tab Find and select "Location condition" "Null value".

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/1D/wKioL1Sp5Oyj3-AvAAKKzJadboQ091.jpg "style=" float: none; "title=" 3.jpg "alt=" Wkiol1sp5oyj3-avaakkzjadboq091.jpg "/>

After selecting the hollow value, enter =E5 in the formula bar. Then press CTRL + ENTER to fill the full.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/21/wKiom1Sp5C-x-2e_AAHBifNTcWo759.jpg "style=" float: none; "title=" 4.jpg "alt=" Wkiom1sp5c-x-2e_aahbifntcwo759.jpg "/>

After the fill is complete, copy e5:e15, paste as value. Complete the first step.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/1D/wKioL1Sp5O3g5uDWAAJCLS5Qi3o277.jpg "style=" float: none; "title=" 5.jpg "alt=" Wkiol1sp5o3g5udwaajcls5qi3o277.jpg "/>

The second step selects the second column of table 1, copy. Select the table 2f5 cell, paste selective, skip empty cells. Complete all operations.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/21/wKiom1Sp5DCBkkaaAAKnWcUuqiQ454.jpg "style=" float: none; "title=" 6.jpg "alt=" Wkiom1sp5dcbkkaaaaknwcuuqiq454.jpg "/>

From the 30-day actuarial Excel exercise

"30 Days of Refined Excel" in the 3rd phase of the hot admissions-training syllabus and application method

Http://t.excelhome.net/thread-43265-1-1.html

This article from "Kirin Tea Room" blog, reproduced please contact the author!

Excel copy-paste-Skip empty cell case