Forum Discussion

rima_ch's avatar
rima_ch
Frequent Visitor
4 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    4 years ago

    Oh--Text.Clean will do that.

     

    --Nate

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Oh--Text.Clean will do that.

     

    --Nate

  • Anonymous's avatar
    Anonymous
    Not applicable

    You've got to get rid of the carriage returns/Lind feeds #(cr, lf).

     

    --Nate

  • Anonymous's avatar
    Anonymous
    Not 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