Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.

Abstract: Aiming at the diversity and flexibility of electric loads and their inherent nonlinearity and temporality in the context of the new era. A forecasting method is proposed combining ...