4 ms·
You should be using PowerPivot in Excel. Here's a video showing rapid pivots of 100m row dataset https://youtu.be/0WwFJ0Zg3d8?t=2285 https://youtu.be/0WwFJ0Zg
by nojito 6y ago
You should be using PowerPivot in Excel.
Here's a video showing rapid pivots of 100m row dataset
https://youtu.be/0WwFJ0Zg3d8?t=2285 https://youtu.be/0WwFJ0Zg3d8?t=2285
- iagovar 6y agoMmm, 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.