Lizardsquid, maker of noises @lizardsquid@computerfairi.es

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

@dwf good luck!

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

@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 this might be a good use for a pivot table!

@anthracite woah I read the start of this back in the day, i should go back to it now it's finished!

@Axel_Hugsky pup!

*wiggles happily*

@NicoleTheLizard@queer.af *squids lizardly*

@NicoleTheLizard@queer.af lizard!!!!

@eri morny!!!

hewwo!

@pup_hime oh, that looks neat!

@pup_hime is this nixos?

@alice that's always the way!!!

New microphone has arrived!

It's on a boom stand, and it's going to take some getting used to having an object suspended in front of my face

@alice welcome to awake!!