How to Get and Transform Query in Excel 2016

In this HowTech tutorial, we’re going to show you how to get and transform Query in Excel 2016.

To get started we will use the Data Tab. You can get a query from a table or start a new query from a Workbook, CSV file, etc.

Get and Transform Query in Excel 2016

For our example, we will use an existed Workbook. When imported, it can be edited right once, if we want it.

Get and Transform Query in Excel 2016

Here we can remove columns, empty cells, add new ones.

Get and Transform Query in Excel 2016

Once you finished, hit Close and Load, and now we have a query loaded into our document.

Get and Transform Query in Excel 2016

If we have error, it meant that this table has an error in its formula, and you can easily fix it through the edit mode.

Get and Transform Query in Excel 2016

If we discard it, the table in our document will show an empty space. Of course, you can apply different style designs and add more columns, cells or data to update your table.