Excel consolidates how to preserve original data

The first thing to do is to select the cells you want to ungroup, and then click Center after Merge, and select Cancel cell merge from the Drop-down menu.

Next connect the Ctrl+g key or press the F5 key, pull up the positioning window.

Locate the criteria to select null values.

Next the original table unchanged, enter the "=" number, and then click on the keypad in the UP ARROW key "↑".

OK, press Ctrl+enter, it's done. Although the technique is very simple, but very practical, the effect is good!