Use Excel's PIVOTBY function to fix your data structure!
The PIVOTBY function isn't just about aggregation. In this video I show a way to use PIVOTBY to restructure an attribute/value table into a nicely formatted table of entities.
For the accompanying file, click here then select 'Download' from the github page:
https://github.com/ncalm/social_conte...
#excel #exceltutorial #exceltips #data #analytics