Help pls with Power Query. Sorry for 2nd post, but here is db problem
15 local copies of the one original file for filling to the employees.
Next after filling i need combine all files in to one table.
How to do it? And what if there are conflicting data? It is necessary to show in a summary table, which fields and which files there are conflicts, to give these files for rechecking managers. Maybe any example for 2 tables in different files?
Data.zip - file PQ_original.xlsx - file for filling.
PQ4 query 1.xlsx and PQ4 query 2.xlsx - files from employes. Need combine to one.
PQ_all.xlsx - the same, just example all in one sheet (real files very large, so, real structure is in the "Data" folder).
Bookmarks