Forum Discussion
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 ...
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 Can you please upload a file that includes the initial data and show how the end result should look like?
Riny_van_Eekelen Here you are. All rows aligned in each column. Allowing me to create a pivot table where each stlyle number has a weekly sales figure and an average sales figure.
Thanks for your help.
Eqa33 Here is a version of the PDF I start with that I bring into Power Query to clean up, in order to create a pivot table.
Eqa33 Thx!
Copied the raw data into the file you sent earlier to understand what you are trying to achieve. Please have a look at the attached file.
I transposed the table first, then split the 2nd column. Is that what you need?
Edit: didn't see you post with "Example3.xlsx" until now!
- Yes, that is exactly how it needs to look. How do I get it there?
When one column has nulls at the top followed by the data and the other columns have data at the top with nulls following after the data. If I filter by nulls in one column, I filter the other columns that have data in their rows.