Re:You Suck at Excel (2015) [video]
by kristianp on Saturday December 21, 2019 @11:15PM
(#21855148)
A Pivot table can be replicated using GROUP BY in sql. Not too hard, but not beginner-level sql either. Not just a few clicks either, it takes some code.
https://modern-sql.com/use-case/pivot