Data restructuration imported from PDF

[medmbchr1989]

Hi

I have imported a set of data from 180 files for a daily client delivery log from PDF files. The issue is that some columns overlaped one over the other one and need to be restructured, the columns are related to : client name, weight delivered and notes/remarks. Hence there should be only three columns.

Link to data below, I need a powerquery tip to resolve the issue.

https://we.tl/t-jWsUqdfHci

Thanks!

[shamili · Accepted solution]

as per given data i saw the client names multiple times .first you have to change weight delivered column datatype into wholenumber and then you have to do groupby with client name with sum or average operation with weight delivered column . 

by following the above steps you can get your funcationality done.
for your reference see the below screenshot.

after completing the above step to add remarak cloumn in to the table add an aditional conditional column and create a new column for remarks and close and apply for the reports.

[shamili]

Hi @medmbchr1989

 l am unable to open the link provided by you @medmbchr1989 

Import the data into power query editor. In power query editor split column using delimeter  or by position and make nessary transformations if needed .

if You found this information useful accept it as solution

[medmbchr1989]

Link expired, there you go: https://we.tl/t-m9dLRZEMEs

Please advise if it's working

[medmbchr1989]

@shamili please advise

[v-jianpeng-msft]

Your solution is so great shamili 

Hi, @medmbchr1989 

Have you solved the current problem? If so, you can mark your solution or helpful reply as a solution so that other people in the community can quickly find a solution when they encounter similar problems.
Your cooperation will help me promote the development of the community! Thank you again!

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.