Bulk Transform Data

Question

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

damian falcone · Answer

Thanks.&nbsp; Putting it into a description others were going to read helped with my searches. I found the answer at&nbsp;https://support.office.com/en-us/article/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4&nbsp;

Forum Discussion

Bulk Transform Data

Share

Resources