You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.)
Exhibit:
You need to transform the data by using Query Editor.
What should you do first?
A. From the Data tab, click Flash Fill
B. From the Insert tab, click Store
C. From the Data tab, click From Table/Range
D. From the Data tab, click Consolidate