Forum Discussion

Brass Contributor

Nov 01, 2022

Solved

In Power Query aligning rows/columns

I have seperated a column within power query where every second entry needed to be extracted into its own column, it is the column called Av. The problem I have is that the other columns called Week ...

Example 2.xlsx10 KB

Formulas and Functions

Riny_van_Eekelen
Nov 02, 2022
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.

Example 5_pq.xlsx26 KB

Eqa33

Brass Contributor

Nov 02, 2022

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

Platinum Contributor

Nov 02, 2022

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.

Example 5_pq.xlsx26 KB

Eqa33
Brass Contributor
Nov 02, 2022
Great. Thank you very much. It was driving me crazy. You have beeen fantastic.
Thanks again.
Eqa