Unstack data with missing attributes using PIVOTBY in Excel!
In the last video, we looked at a way to use PIVOTBY to unstack badly formattted data. That method relied on each entity having the same number of attributes.
But what happens if some entities have missing attributes?
Here's one way to deal with it.
For the accompanying file, click here then select 'Download' from the github page:
https://github.com/ncalm/social_conte...
#excel #exceltips #exceltricks #exceltutorial #data #analytics