fix(Data): For data downloaded as a csv, display expedition names in column 1 instead of row 1

[haflanagan]

On the Data>Download page, when you download the data as a csv, the expedition names run horizontally across the spreadsheet in row 1. It's more useful for our participants to have the expedition names run vertically down the spreadsheet in column 1, and for the selected parameters (like salinity or oyster measurements) to run horizontally across the spreadsheet in row 1.

This is how it currently displays:

This is how we'd like it to display:

[irag]

Doesn't Excel have a Transpose function that will do what you are asking? On my copy of Excel 2000, it appears as Paste Special > Transpose.

[haflanagan]

@irag Excel definitely has this function, and it's what we advise people to do in our Data guide, but middle school students are generally pretty new to Excel (and to be honest, a lot of teachers aren't even super comfortable with Excel). The goal would be to put it into a more logical/readable format from the start so there are fewer barriers to entry.

[irag]

@haflanagan That makes the info a workaround until you put in the change. You could say something like "If you want to swap the data so columns become rows and rows become columns, we suggest the following ... ". You can even transpose in google spreadsheet. The question is whether this BOP software is going to make up for the general public's lack of tech knowledge or should it not and strive to educate them as to what's possible. That is certainly a determination I would not make.