User-friendly, affordable, and packed with different features, DocHub is a healthy and cost-efficient alternative to Ascend ECM. 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 a copy of all credit card statements from the past year. Chandu used Power Query to combine 12 PDFs into one Excel table, removing unnecessary information before sending it to Barry. The credit card statement has header details and a transaction table spanning multiple pages. To get a single statement into Excel, go Home, then data, and get data from file from PDF in Office 365. This process can be repeated for multiple statements to create one table.