After you install the May 2, 2017, update for Excel 2016 (KB3191861), the following Get & Transform features are updated in Microsoft Excel 2016:
- SAP Hana connector improvements: Enhancements to Parameter Input UX
- New transformation: Add column by example
- New transformation: Split column (by delimiter or number of characters) into rows
- New transformation: Group By - Basic mode
- Navigate to the column in the query editor
Third-party information disclaimer
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.