2 ms·
Well, for me with my personal PC with a quad core and 24gb DDR3, it gets unusable for about 1 million rows, but it's true that most of my datasets have around 1
by iagovar 6y ago
Well, for me with my personal PC with a quad core and 24gb DDR3, it gets unusable for about 1 million rows, but it's true that most of my datasets have around 10 columns or so.
- nojito 6y agoYou 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.