Forum Discussion
Data restructuration imported from PDF
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.
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
Link expired, there you go: https://we.tl/t-m9dLRZEMEs
Please advise if it's working
shamili please advise
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.
