Power Query crazy format

Anonymous,

In power query, you may refer to steps below(Unfortunately simply "Unpivot then pivot" can't achieve the result you want):

Firstly duplicate the original table, then you have two tables 'table1' and 'table2', in table1, click on columns [AmountType1], [AmountType2] and [AmountType3] then click Unpivot, remove all the useless columns like below:

Then filter the blank values in Value column and add an index column:

In table2, click on columns [Amount1], [Amount2] and [Amount3] then click Unpivot, remove all the useless columns and add an index column:

Finally, merge table1 and table2 based on index column.

You may refer to the appendix.

Regards,

Jimmy Tao