Data view

Hi Sonne ,

In the power query, the merge logic of append is based on matching the names of the fields. Column names that do not exist in the original table will form a new column and will be null at the corresponding values.

If you don't want to display these null values, you can refer to the following operation.

If the problem is still not resolved, could you further describe your requirements and provide screenshots of your expectations accordingly. I will be able to answer your questions as soon as possible. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.