Use the Power Query Editor

The data from the Line of Business database is in the wrong format for analysis. We’re going to manipulate it using the Power Query Editor.

Open the Power Query editor as shown. This will open a separate window. Power Query Editor