
Realize functions:
1) the data import Power Query


Click "data" above the layout module, select "from the" import data, click on the confirmation, will appear Power Query layout, data successfully imported,
2) the size of the first number to extract a single column (number) before the first *

First of all, a copy of "size" of the data, by right click on the "size", select "repeat the column" implementation;

Then left in the copy of the "size" point, and at the top "transformation" module choice "to extract" - "to extract the text before the delimiter";

Followed by the delimiter is set to need to extract the text after the delimiter, here as "*", click on the confirmation, text extraction out

3) remove the category last colon

Click "category", "transformation" above module choice "replacement value", and ":" replace "" (space)


4) size is divided into three by three columns


Click "size" in the "transformation" module selected above "coming down the" - "by the separator", enter the separator '*'
Completed, renamed as "long", "wide", "high"
5) repeat part of the delete table

In the above "home page" choose "delete line" - module "delete duplicates"

6) add custom area of column

In above under the "add column" module to select "custom list", and at the command input box "=[long] * [] wide"
Get a custom column "surface" and the corresponding value

7) results will upload to excel in

After the completion of this form will be updated with the update of the original excel spreadsheet, just click the "refresh all" under the "data" module can ~


