Microsoft releases eight new data transformation and connectivity features for Get & Transform in Excel 2016
1 min. read
Published on
Share this article
Improve this guide
Readers help support MSpoweruser. We may get a commission if you buy through our links.
Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more
Microsoft today announced eight new data transformation and connectivity features for Get & Transform that have been requested by many customers. Find the list of new features included in this update below.
- New transformation features:
- Add Column by Example.
- Split Column (by Delimiter/Number of Characters) into rows.
- Basic mode for Group By operation.
- Extract Text Before/After/Between Delimiters.
- Unpivot Only Selected Columns.
- Combine Files experience—ability to reference first file as example.
- New Go to Column in Query Editor.
- SAP HANA Connector—enhancements to Parameter Input UX.
These updates are available for free as part of an Office 365 subscription. 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. Read about all these improvements in detail here.
