Empty lines

[rima_ch]

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.

[v-stephen-msft]

Hi @rima_ch ,

Could you tell me if your problem has been solved?

I agree with @watkinnc . Text.Clean is good.

If the problem has been solved, please mark @watkinnc 's reply as solution.

Best Regards,

Stephen Tao

[watkinnc · Accepted solution]

Oh--Text.Clean will do that.

--Nate

[watkinnc]

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

--Nate