Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
207
Views
Topic starter
Working through the Power Query Unpivot - fix 4 Common Data Layouts.
When I am ready to select Close and Load to, I do not see the same options shown in your video. I am using MS Excel 2013 and have upgraded my Power Query in MS.
Posted : 03/02/2022 6:36 pm
Hi Bill,
Welcome to our forum!
Unfortunately, Excel 2013 does not have the newer options to load to PivotTable and Pivot Chart. There's no way to get them other than to purchase the latest version of Excel (2021) or get a Microsoft 365 subscription. If you were to upgrade, I would strongly recommend you do not get Excel 2021, as it's already out of date.
Mynda
Posted : 03/02/2022 7:39 pm
Topic starter
Thanks Mynda. I really appreciate your tutorials and useful information.
Posted : 04/02/2022 9:28 am