Customize data refresh|Power Query|Excel Forum|My Online Training Hub

Hello! 

I'm running PQ to fetch data from a folder (which has roughly 50 workbooks). When PQ refreshes the data, it appends all the new values after each workbook. Something like this

Workbook 1

Workbook 1(new Values)

Workbook 2

Workbook 2(New Values)

and so on!

Can I have it otherwise, instead of appending data it should add new rows for all the new data that is entered in each workbook. Like this

Workbook 1

Workbook 2

Workbook 3

Workbook 1(New Values)

Workbook 2 (New Values)