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.