Why does importing data from SQL look like this? Should I clean/trim in power query?

[Anonymous]

Hi all - please take a look at the data I imported from SQL.. Is it suppsed to be all spaced out like this?

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

It may be because there are many blank lines in your text format string.

The method to eliminate blank lines is as follows

1.Right-click and select Split Columns.

2.Modify the number of columns to be split to 1.

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.

[jaideepnema]

Hi @Anonymous ,

Do you have only these many columns in your table ? or there are other columns as well.