User-friendly, affordable, and packed with different features, DocHub is a healthy and cost-efficient alternative to Archive One. Try it now and learn how to squeeze the maximum of our solution with easy-to-use feature shortcuts.
Barry, the accountant, asked Chandu for his credit card statements for the past year. Instead of manually copying data from 12 PDFs, Chandu used Power Query to combine them into one Excel table quickly. Chandu demonstrates how to extract a single credit card statement into Excel and then proceed to merge multiple statements into one table. This process is made easier by using the "Get Data from File" option in Excel, available in Office 365.