Forum Discussion
AnalystNerd
Mar 03, 2022Copper Contributor
Pivot Table or add columns to regular table?
Hello fellow Excel nerds! I have an oddball issue that I'm struggling to figure out how best to approach. Basically, Ive got a decently large dataset (100k - a mil rows), each one with multiple def...
AnalystNerd
Mar 03, 2022Copper Contributor
Side note - I've very limited experience with plugins like powerBI, power-pivot, or VBA, I'll happily take advice including these if they make life easier, this will bea repeated thing so the ability to replicate the process will be amazingly helpful as well