Power Query often automatically adds a ‘Change Type’ step after loading data to try and assign data types to columns based on the first 1,000 rows. If your data includes inconsistent types, such as ...

I'm making a script that will write a two-dimensional array to an Excel spreadsheet. The script is meant to be called from within other scripts. An outer loop runs once for every row in the array. An ...