Forum Discussion
return blank after appending
Hi all,
I appended 8 excel files and the new appended files shows many blanks that were not in the original excels, any idea what can it be and how to fix it?
thanks!
You can remove blanks in edit query/ transform data mode.
If the data is configured as tables in Excel, make sure that you are selecting the tables in the Merge operation.
If it's just cell grids, you'll get white space because you don't know where the data actually ends up. Next, you'll need to remove blank rows in Power Query.
However, the best thing you can do if possible is to make sure that the original data is in Excel tables (press CTRL-T on the data), and then Power Query knows where the data starts and ends.
4 Replies
Would need to get a sense of the data, but you can remove blank rows in Power Query
You can remove blanks in edit query/ transform data mode.
If the data is configured as tables in Excel, make sure that you are selecting the tables in the Merge operation.
If it's just cell grids, you'll get white space because you don't know where the data actually ends up. Next, you'll need to remove blank rows in Power Query.
However, the best thing you can do if possible is to make sure that the original data is in Excel tables (press CTRL-T on the data), and then Power Query knows where the data starts and ends.
Hi Anonymous ,
Append Queries requires that two or more tables to be merged have the same number of columns and corresponding column names, otherwise null values will appear.
Example:
table1
table2
Append table:
In addition, even if the data types of the two columns from the two tables are different, as long as the column names are the same, they can be merged into the same column.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
