Forum Discussion
rima_ch
4 years agoFrequent Visitor
Empty lines
Could someone please tell me how can i get rid of empty lines in a row, i see something like this in power query
when doing group by [Column 1] it's like i am having two diffrent column(but it should be the same A), i tried to delete balnk space but no it's not working i still see the same thing, what should i do.
Thank you in advance.
- Anonymous4 years ago
Oh--Text.Clean will do that.
--Nate
3 Replies
- AnonymousNot applicable
Oh--Text.Clean will do that.
--Nate
- AnonymousNot applicable
You've got to get rid of the carriage returns/Lind feeds #(cr, lf).
--Nate
- AnonymousNot applicable
Hi rima_ch ,
Could you tell me if your problem has been solved?
I agree with Anonymous . Text.Clean is good.
If the problem has been solved, please mark Anonymous 's reply as solution.
Best Regards,
Stephen Tao