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