I have a data set that looks like:
9018.010.00008
9018.010.00007
(Blank)
(Blank)
(Blank)
AKM32C-ACC2R-00
(Blank)
152.01.100
I want it to look like:
9018.010.00008
9018.010.00007
AKM32C-ACC2R-00
152.01.100
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
This technique works if there’s a column in your table that helps to see if it’s an empty row or not (a key column). for instance, it are often a client ID or order range or something similar.
It is necessary to save lots of the rows order, thus we will not simply type the table by that column to move the blank rows to the lowest.
Use Filter Button for this issue and click here for better understanding with screenshots.
message edited by aren111
Another quick way is to
Select your range of cells
Click F5
In the Go To dialog box,
Click Special.
Click the Blanks option
Click OK.
On the Home tab,
Click the Delete drop down
Choose Delete Cells.
Excel should display the Delete dialog box,
Select Shift Cells Up option
Click OK