Hello!  I'm hoping to use PQ to routinely clean up data exports from our acctg software and I'm new to PQ.  My challenge - if I export into an excel file, the first row of data is always in the wrong column which creates a problem.  I generated the export into pdf format and the result is a multi-page PDF that has identical header information (I'm thinking column names) on each page but there may be no data in an entire column on some of the pages. 

When I "Get Data" my options are 16 TABLES and/or 65 PAGES.  The later generates 65 different sheets in my workbook - bummer.  I assumed the appropriate action was to select all TABLES and launch PQ to clean it up. That brings me to another problem: I've got 16 different queries and the data structure isn't the same for the reason mentioned above (no data in a column on one of many pages of the pdf). 

I know I can clean up the excel version of the export and use the resulting file in PQ to do the rest of the "cleanup" but it seems counter-intuitive to do so.

Am I missing something?

I appreciate any direction you can give this newbie.