were going to show you how to get and transform Query in Excel 2016.
Don't forget to check out our main channel for more free how-to videos!
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
Ross: 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 dont have this. My get & transform is limited. I found transpose in the customize ribbon. but it is greyd out and not useable. Someone please help Date: 2023-07-08
