Automate the Data reconciliation

[sabaresh]

Hello,

I am new to Power query, so I need some input for the problem which I am trying to solve. I am trying to automate the data reconciliation task which I am doing manually. I have list of excel files (which has lots of sheets) in the folder and have to extract 5th row from different sheet from different excel. so, I want to create a configuration which tells what sheet's row needs to be extracted from each excel and append all the rows. Can you tell me how can I do this in Power query?

thanks in advance,

Sabaresh

[v-yuta-msft]

Hi sabaresh,

Please refer to the similar case: https://community.powerbi.com/t5/Desktop/Delete-top-rows-from-multiple-imported-files-at-once-and-co....

Regards,

Jimmy Tao

[sabaresh]

Hello Jimmy,

thanks for the response. 

As I mentioned in my post, I have multiple sheets in each excel and I don't want to take data from all the sheets. for eg.

I have excel with employee names A, B, C, D, E and each excel have different sheets 1, 2, 3, 4, 5.

I will have a configuration which says A -> 1, B-> 3, C ->3, D -> 4.  So the final merged excel will have only data based on configuration.