Excel 2016 comes with a set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform allows users to connect, combine, and refine data sources to meet their analysis needs. Microsoft yesterday announced two new data transformation and connectivity features for Get & Transform that have been requested by many customers. Read about them below.
New transformation—horizontal list expansion: With this update, they have made it easier to extract data values from a column containing nested lists. It is accessible via the column headers in a List column, or by using the Expand ribbon entry point.
Enhanced SQL Server connector—support for SQL Failover option: They have improved the SQL Server connector and added a new option to enable SQL Server Failover support. This new option can be found under the Advanced Options section in the SQL Server connector dialog.
These updates are available for free as part of an Office 365 subscription. Read about all these improvements in detail here.