Put in columns the variable that's going to be the class, we'll use species.
To use Excel, try the pivot table option. I will use the penguins dataset as example, as I don't have access to your data. Anyway, for the sake of answering, I offer my solution. I know it's an old one, surely you've found a solution time ago. I just dropped by here and saw your question today.
