Forum Discussion

gvg's avatar
gvg
Post Prodigy
4 years ago
Solved

Ellipsis in Power query value field

Hi,

I just came accross this weird thing in Power query editor. What do those ellipses in value field mean? They also appear as separate items when I try to filter column (second picture). In reality those cells must be blank.

 

 

Would be gratefull for any hints.

  • OK, this must be rows that do not fit in column widths. Doing Trim help to get rid of them.

2 Replies

  • gvg's avatar
    gvg
    Post Prodigy

    OK, this must be rows that do not fit in column widths. Doing Trim help to get rid of them.

  • Anonymous's avatar
    Anonymous
    Not applicable


    Good to here that, glad you solved.

     

     

    Paul Zheng _ Community Support Team