title: How to create pivot table with huge dataset?
body: <p>I have a <code>txt</code> file that is 80 Mb . Tried import it to excel but it worked only partially. Not all datapoints were imported. I need to create pivot table. How can I do this ? Is there any way I could have this external connection to <code>txt</code> file that is on my computer and build a pivot </p>