Today, we’re going to import data from the web to Excel. We’re going to be using get and transform from the data tab. This used to be the Power Query add-in, but since Excel 2016, it’s a part of Excel.
This is the top 15 advanced Excel 2016 tips and tricks. As a follow up from the top 25 Excel 2016 tips and tricks video, here’s some additional advanced features. If you missed the original top 25, follow the link
If you try to unstack data in excel from one column to multiple columns, you’ve probably noticed it’s not as easy as you might have thought. You might google it, and you’re going to find many different solutions to this.