Can someone help me understand how I can join multiple excel files together with the same schema of 3 columns (account name, debit balance, credit balance) in 12 monthly excel files with different amount values posted? The excel files are for each month and some accounts may be different from month-to-month as well. I want to combine all of the excel files so that way the accounts won't have duplicates and the debit and credit balances will be presented horizontally.
