I have an Excel spreadsheet (Excel 2011 for Mac) with 1175 rows containing species names (431 names total) and 72 columns (A:BT) of months from October 2011 to August 2017. Each row only has one cell of information (besides the species name), but some species have multiple rows, and the number of rows per species varies.
I would like to combine rows with the same species name into one row, but keep the column data in the correct respective column.
Screenshot of what I'd like the table to look like, based on the partial view in the first screenshot
Because every row only has one cell filled in, a way to merge columns of data with the same species name (keeping the one value that might be in the column) or collapse all the rows with the same species name into one row is basically what I'm looking for. I tried creating a vlookup function to create a new table based on the species name, but could only ever get it to pull in the first column with data for that species or the last column with data.
Any help is greatly appreciated! I'm hoping I don't have to go through and do this all by hand.