Trick 016 Consolidate complex data tables into simple tables with power query

     In the process of processing the work, we can get a complex data table with many different rows and columns. The data tables are not in sync format. 

    Therefore, in order for us to have a clear and clear report, we need to process these data tables before making the report.

  And here is a small example to make the data table from complex to simple with power query