View Single Post
 
Old 08-09-2022, 04:27 PM
JHalter JHalter is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Nov 2021
Posts: 46
JHalter is on a distinguished road
Default Deleting Multiple Rows

I copied over a list to excel which has data in row 1, then row 2 and 3 are blank, and data in row 4. This goes on for about 2000 rows. How do I quickly delete the 2 rows that are blank in between the cells that contain data?

Looks like this...

123
blank
blank
456
blank
blank
789
blank
blank
Reply With Quote