Forum Discussion
In Power Query aligning rows/columns
Eqa33 The PDF cleared up matters. The file contains 8 tables. The last three are inconsistent with the first 5. Some of the "header" rows have the 6xxx number combined with the [image] (see picture below)
This is really messing up the entire process, so I took these last three tables out. The other 5 tables neatly transform into the kind of table that you need. See if you can do something about the PDF files so that these odd cells like in the picture do not occur.
See attached. Just point the Source to the PDF on your own system.
Eqa33 That file connects to a folder on your local PC, so I can't see what you are doing. I can "expand" the pivot table and see the underlying data but that creates a table like you had in your example.
From the transform function I see you connect to Table001 in the PDF document.
So please upload one PDF file or connect to the folder with the PDF files, perform the first steps that expands the tables and load that back to a table without any of the following transformations. Then upload that Excel file.
- Great. Thank you very much. It was driving me crazy. You have beeen fantastic.
Thanks again.
Eqa Eqa33 The PDF cleared up matters. The file contains 8 tables. The last three are inconsistent with the first 5. Some of the "header" rows have the 6xxx number combined with the [image] (see picture below)
This is really messing up the entire process, so I took these last three tables out. The other 5 tables neatly transform into the kind of table that you need. See if you can do something about the PDF files so that these odd cells like in the picture do not occur.
See attached. Just point the Source to the PDF on your own system.
- I want to take the PDF and create a pivot table that can be added to weekly so that I have a running history of the sales of each style rather than a weekly snapshot that doesn't really allow me to see sales week by week, month by month etc.
Riny_van_Eekelen It looks different because I had started to clean it up and then got stuck.
Eqa33 OK, but this looks totally different from what you uploaded earlier. I had hoped for some consistent structure but can't discover it. Sorry!
Please let me know what the end result should look like and the logic behind it. And perhaps also good if you upload the PDF itself (i.e. the file Winners Oct 22.pdf)