I have a huge CSV file that is too large to put into a worksheet and CSV is the format I have it in.
I want to use a pivot table to mine that data but I have no idea how to link a CSV to a Pivot. I downloaded an ODBC driver (no idea what it is) and cant make head nor tail of what stuff on google tells me. Does anyone have any bright ideas? It would appear that because I have Mac and am on Office 365, I don't have the Power options that would otherwise render this easy?
Cheers, in advance