To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...
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, ...