I have a cpuple tables loaded as a connection in a worksheet to be appended in on sheet as a single table, but appending those tablea also append blank rows in between and there ate a lot of them.. My source tables don't have any blank rows, have no clue where6they are coming from. Any help is appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Query Appends Blank Rows in between
- Thread starter powerwill
- Start date
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,256
- Office Version
- 365
- Platform
- Windows
When you say it adds blank rows "in between". Do you mean what is effectively at the end of each table ?
It is most likely in your source data ie your tables extend beyond where the data finishes.
If you don't want to address it at the source then delete them in PQ.
Home > Remove Rows > Remove Blank Rows
It is most likely in your source data ie your tables extend beyond where the data finishes.
If you don't want to address it at the source then delete them in PQ.
Home > Remove Rows > Remove Blank Rows
Upvote
0
Solution
Similar threads
- Solved
