CDVS Workshop: Excel Power Query to transform and aggregate data

When I need to convert a table from wide format into tall (unpivot) or combine two spreadsheets by matching rows based on a key column (JOIN/merge), I used to turn to Python, R, or OpenRefine. It turns out you can do both of these operations right in Excel using Power Query! In this workshop I'll lead you through a quick example using survey data, where I unpivot and merge both the text and numeric versions of responses into a single table that's ready for analysis and visualization. Plus, I will show you how to summarize data in a way that surmounts a limitation of pivot tables for visualization. This event is open to non-Duke participants.