How to quickly fix CSV files in Excel using Power Query
Web apps love exporting CSV files, but they don’t always play nice with Excel. Leading zeros disappear, dates break, and text fields merge together. Most people waste time fixing these problems manually, even though Excel includes a built-in Power Query tool that automatically cleans and reshapes messy data in seconds.
[mai mult...]