@coriander this might be a good use for a pivot table!

@coriander so a pivot table allows you to take one chunk of data, and express it in a different way.

Make sure your data has headings, then select all of it. In one of the ribbon options (I don't remember which one in Google sheets), there will be an option to make a pivot table.
Once it's made, you'll get a piece of UI to drag different elements in different places - mess around with it! It's all dynamic, so you're not going to accidentally delete anything.

@coriander great!!!! Pivot tables are extremely useful (especially if you've got a huge table of data)

@coriander I meant more: if you have lots of columns, you can do lots of different transformations!