Get and Transform Power Query in Excel 2016

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

Join us on Facebook
Our App

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.
For our example, we will use an existed Workbook.

When imported, it can be edited right once, if we want it.
Here we can remove columns, empty cells, add new ones.

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

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. 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.

This is a HowTech tutorial, visit our website and watch our videos for more.

[Conde]

Can you start a new query from a csv file on Excel for Mac?

[rossfontana]

OK. I feel like a complete idiot. I have watched the videos and cannot figure out why I do not have all the functions that I see in these tutorials available to me. I have completed the add-in and do not have the ability to transform data. The last few seconds of this tutorial brings up a Query page (Smiley face in the upper left corner. I don't have this. My get & transform is limited. I found transpose in the customize ribbon....but it is "grey'd" out and not useable. Someone please help