Bulk Transform Data

Copper Contributor

I have approximately 100 client ledgers in excel.  The format, data types, and naming convention are consistent through the 100 ledgers.  Looking for the best way to merge the ledgers while maintaining the events (due date, receipt, deposit) specific to the clients.

1 Reply

Thanks.  Putting it into a description others were going to read helped with my searches. I found the answer at https://support.office.com/en-us/article/combine-files-in-a-folder-with-combine-binaries-power-query...