PowerQuery Puzzle solved with R

#165–166PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #165Today we get table with data which we suppose to transform into shape of Excel Pivot Tables (aka Cross…