Unique list from table in Power query (don't show 'NULL')

[danhendo888]

https://1drv.ms/x/s!AvjBsEPEq12ngSTtNlKRTZmnoBHr?e=k1ek3y

I have created a Custom Column using List.Distinct on the Payment Date column.
If I expand these values, the NULL values will also appear.
How do I make it such that it only shows the dates when I expand the values in Power Query?

That is, only the first two rows where highlighted should show dates.

EDIT: I think I figured it out. I can just expand and use the SPACE delimiter

 

[sandy666]

in your example null exist only in PQ Editor. If you load table into the sheet you will not see null

 

[danhendo888]

in your example null exist only in PQ Editor. If you load table into the sheet you will not see null

The problem with NULL showing in PQ editor is that it still creates new rows.
However, I think I found a way around it: just produce the values into one cell using SPACE delimiter. Then my rows are maintained.

 

[sandy666]

As you wish , have a nice day

 

[danhendo888]

Hey guys,

How do you keep track of number of rows in PQ editor for large tables where it just says 999+ rows?