In my mind, Excel can treat data however it wants. Things can be redefined. The import data process has a "Transform Data" button. Click it. It opens a window w

In my mind, Excel can treat data however it wants. Things can be redefined. The import data process has a "Transform Data" button. Click it. It opens a window where you can check the data and manually edit the query. It's called Power Query. They aren't even using the tools right there in front of them to fix these things. Imagine them using Python and R.