Adding Columns to table in power query

Jacobus Botha, Mr 1 Reputation point

Good day

I would like to add a column from another workbook to a table in power Query. The problem I am facing is that the raw data set which I am receiving contains all of the past months' and years' information. I only want to extract the last Column of the received data set and add it to the table in power query every month. I tried making a dynamic table but that adds new rows at the bottom of the table and inserts null values in the column of the table where I want to add this months values.
Below is the result that I'm getting currently and the code that I have been using.


As seen in the image I want to replace those null values with the values beneath them. I also want to remove all the other data that is duplicated due to them being in both workbooks. Only the new months' values need to be added to the table.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,728 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee

    Hi there. Power Query is no longer supported here on Q&A. Please post your question over on instead.

    0 comments No comments