You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.)Exhibit:You need to transform the data by

[answerhappygod]

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?

You Have The Ex 1 (90.31 KiB) Viewed 71 times

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