Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 28

The Power Query Editor

Questions answered in this chapter:

• How can I import the population of US cities into Excel?

• How can I flatten an Excel table?

• How can I create a table from a flat file?

• I have data on NBA players by team, but each team name occurs only once. How can I easily fill in each player’s team and place each player’s statistics in a separate row?

• When I import hardware store sales data into Excel, the data is in an incorrect format. How can I ensure my imported data always has the correct format?

• How can I easily combine all files from a single folder into a single file?

• Suppose I import daily suggested prices from corporate headquarters, and for each day in May I want to reduce corporate’s suggested price by 5 percent. ...