The P04_07.txt file is a text file listing the number of mobile subscriptions in four years for

Question:

The P04_07.txt file is a text file listing the number of mobile subscriptions in four years for several countries. (You can view the data in NotePad if you like.) Use Power Query to import the data into an Excel table, using the Query Editor to delete the first and last columns and the last four rows. The result should be a table with three columns and four rows for each country, one for each year. An alternative arrangement has five columns (Country, 2002, 2003, 2004, 2005) and one row per country. Show that you can create this alternative arrangement with a pivot table based on the imported data.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Business Analytics Data Analysis And Decision Making

ISBN: 9780357109953

7th Edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: