News for hackers. Stuff that matters.
Re:The pivot table, the spreadsheet's most powerful tool (2020) by hermitcrab on Monday October 09, 2023 @01:06PM (#37822602)
Have you tried Easy Data Transform? It is a lightweight ETL tool for doing data transformations (such as pivot) on Excel, CSV and various other file formats. Runs natively on Windows and Mac.
Re:The pivot table, the spreadsheet's most powerful tool (2020) by tqi on Monday October 09, 2023 @03:34PM (#37824399)
The ETL part is not really the problem business users seem to have, but rather needing the ability to use pre-built measures / dimensions natively in Excel.