You should be using PowerPivot in Excel. Here's a video showing rapid pivots of ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		nojito on May 23, 2020 \| parent \| context \| favorite \| on: SQLite 3.32 You should be using PowerPivot in Excel. Here's a video showing rapid pivots of 100m row dataset https://youtu.be/0WwFJ0Zg3d8?t=2285

spaniard89277 on May 23, 2020 [–]

Mmm, I was using PowerQuery and then use the editor to do the transformations (don't remember exact names sorry), and I just couldn't cope with it.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact