ETL transformation table needs to be based on an original table, we need to import this excel into BIDemo business package, see excel import. After importing you can open this excel dataset to view it. As shown in the figure is to open the dataset:

The table to be converted to add the completion of the table, click on the right side of the ETL processing in the middle of the table name button, select "to the table - row and column transformation", into the row and column transformation configuration interface, the following chart:

Set up the completion of the effect is as follows:

Click the Save until you return to the table settings page.