Forum Discussion
Solved
Clean data in Power query editor
I have data that I am trying to clean in the Power query editor The output should be like this- I am facing issues while filtering the null from value, column 3 and column 6...
Hi amikm ,
There is a question why the numbers in the sample data are empty, and the results will be 2 and 2863?
At present, according to my own understanding, I made the expected results as follows, if in doubt, please let me know.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi amikm ,
There is a question why the numbers in the sample data are empty, and the results will be 2 and 2863?
At present, according to my own understanding, I made the expected results as follows, if in doubt, please let me know.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.