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, ...
Keyboard shortcuts can supercharge your workflow - if you know what they are. Here are the ones I recommend to every user.