Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...
To make the most of the UNIQUE function, you should make sure your array is in an Excel table. By using a table name rather ...