Originally Posted by
CK76
Personally, I'd do all transformation in PowerQuery and skip loading tables into sheets. If you can upload sample source files. I can show you steps.
If that's not feasible. You'd load each table as connection only to PowerQuery.
Remove all unnecessary columns from each table and make sure all remaining column names match from table to table.
Then using one of the query, "Append Queries"->three or more.
Highlight all columns and "Remove Rows"->"Remove Duplicates".
Change column data type as needed and load to sheet (or data model).
See attached sample.
Note: I didn't filter out "null" values, but you may want to.
Bookmarks