Fuck pivot tables. I’ve seen more ignoramuses piss away more hours trying to get that shit to work… When it could have just been done, reviewed, fixed and issued in half the time.
Maybe it’s because all the people I’ve seen try and sell me on them were dipshits, but fuck pivot tables.
Also, x2 on the shitty import wizard of excel. [/quote]
Pivot tables are great when you have a lot of data to organize and make basic sense out of (sums, counts, etc.) as long as the data is set up in database format.
If not, I agree it can be a big pain in the ass and it’s just as easy to sort it “manually” and plug in formulas (as long as you know what formulas to use/how to use them).
Tool for a job is all it is. Gotta know what you’re building before you pick the tools for the toolbox.[/quote]
Pivot tables are easy as hell to use. I don’t really see the issue. [/quote]
The issues i’ve run into with using them has largely to do with the structure of the data I’m trying to convert … mainly data cleaning issues. Sometimes I’ll get some shit that has absolutely no structure and it’s just a bunch of fucking jumbled data that needs to be sorted. Luckily I know a thing or two using logic loops so I can sort that shit out somewhat quickly. Plus when I’m trying to marry two sets of data from different databases, a pivot table is fucking useless until it’s cleaned and uniform.
To really use pivot tables effectively it needs to be in database structure otherwise you’re going to end up pissing in the wind. [/quote]
I think you mentioned SQL, which would work too, but imo it’s no where near as user friendly. SQL queries can be confusing especially at first and changing data is a pain in the ass imo. [/quote]
Absolutely agree. There’s a reason no one likes to talk to IT/Data guys