Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.
Windows disconnects idle devices if power-saving options are enabled. This could be the reason why your mouse or keyboard keeps disconnecting. Here is how you can turn off power-saving options: ...