After you install MS17-014: Description of the security update for Excel 2016: March 14, 2017 (KB3178673), the following Get & Transform features are available in Microsoft Excel 2016:
- Enhanced SQL Server connector - Support for the SQL Failover option.
- New transform - Horizontal list expansion.
- ODBC and OLE DB connectors – Support the Select Related Tables function.
- Enhanced folder connector – Support the Combine function from the Preview dialog box.
- Unified text and CSV connectors.
- The Change Type Using Locale option on Column Headers Type menus.
- The Insert Step After option on the Steps pane.
Article ID: 3141518 - Last Review: ಮಾರ್ಚ್ 14, 2017 - Revision: 11