power query- Export only month data instead of YTD Data

[Sonam_Pillai]

Hi,

I am working on YTD data Jan- Sep however i dont want previous data to change.

Is there any way that i can only append September data while doing close and load.

Means if my data from Jan to Aug is A2 to A1000 my sept data will get loaded from cell A1001 without doing any changes in historical data.

[v-piga-msft]

Hi @Sonam_Pillai,

If I understand your sceanrio correctly that you have a data like below but you only want to load the data highlight in yellow?

Best  Regards,

Cherry

[Sonam_Pillai]

NO. 

After all the power query done and when we load that data into excel file, In that excel file data need to be appended and not to be replaced.

if in excel data range is A1 to A100 then powerquery data need to get append from A101