I have been looking at wind speed data from various locations. And I'd like to export this to excel. That part works. But the data are difficult to work with in excel. This is what the raw export looks like.
I'm thinking there must be some modifier within Mathematica that allows me to export the text and numbers in a row and column format that is more typical (Column A Date, Column B Time, Column C wind speed). I tried the DATASET, and that folds the large file together, but still with only a dozen rows and thousands of columns of information mashed together.
All the data are on a single row. I have to copy, paste, transpose to get the information to look something like the image below. Also, if its a large data set, XLS/CSV format only accepts a limited number of columns. There must be a switch somewhere in Mathematica that lets me export a more workable format.
Ultimately, this is what I want to see, and work with: