This video describes how to think about the structure of a complex set of data. It is of particular use to anyone assigned to scrape a complex website, and also to anyone working to merge different datasets (e.g. in Stata).
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.