Nonprofit Technology Chat: 3 Cool Things to Try in Excel 2016
With the new Get & Transform capabilities in Excel 2016, you can now import, transform and combine data from different sources—thanks to the integrated Power Query technology in Excel. Today we are going to focus on one of the most useful capabilities that Get & Transform offers—the ability to use Unpivot to transform ANY table in your workbook to make it ready for powerful analysis using PivotTables and PivotCharts.
Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform enables you to connect, combine, and refine data sources to meet your analysis needs.