Forum Discussion
Solved
Cleaning Data
Hi, I am looking to reshape some messy data from a PDF table as in the example below, to create the table below that. I can perform this transition (i think) with many, many, many applied ste...
Hi tomshaw83
I'm not sure if my solution is more efficient than yours. But my solution is all processed with the user interface without needing to modify the M codes in Advanced editor. You can download the attached pbix file to check specific steps.
To make it clearer, I deal with the data in separate queries and combine them at the end.
Hope this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Thank you, some useful techniques in your solution