Is there a way remove rows that have blanks in one short with bunch of tables in the middle. Each table is separated by space.
Excel remove blank rows in one action
Hi, @JonathanBrotto-3536
I'm working on it and will reply when there is progress.
I see the solution and did try the go to statement but when I try to delete with ctrl + space bar and then ctrl - it does not work.
Hi, @JonathanBrotto-3536
To help you better, please provide a sample screenshot of where the cell to be deleted is located. The following method is for your reference:
Use Ctrl+Delete to delete the contents of the cell, and the selected cell cannot be deleted. It is recommended to right-click the selected cell and select Table Rows in delete.
Hi, @JonathanBrotto-3536
I want to help you but I don't know the specific problem you describe, please provide a simple case and attach a screenshot, so that I can help you better.
Here is a possible case for your reference, delete the blank rows between the above two tables.
If you want to batch delete blank rows between multiple tables, you can use the positioning method:
1. First click any blank cell, press the shortcut key Ctrl+G to call up the positioning window, click Location Condition in the pop-up window, select Empty value, and then click OK.
2. Then go back to the Excel table, the blank cells are marked, right-click to select Delete, and click Entire Row - OK.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Excel 365 Pro Plus with Power Query.
Append space separated Tables.
With Table sources.
PivotTable ready.
https://www.mediafire.com/file/qdb8cluaesoiaow/03_31_22.xlsx/file
https://www.mediafire.com/file/fsogygk60o17o67/03_31_22.pdf/file
4 people are following this question.
