Working with tables

Tables are structured collections of rows and columns, where each cell can hold data of any type. They are the predominant structure in Power Query, as evidenced by the way the UI has been designed to operate on them. Now it’s time to explore the basics of nested tables and see examples of how to create, access, and manipulate them. Our primary focus is on understanding the nuances of working with a nested table structure.

Here’s our sample dataset. Call this query SurveysData; we will refer to it using that name from now on:

let
    Source = Table.FromRows( List.Zip( { List.Transform( {"1".."5"}, each "Wave "& _ ),
        Table.Group( Table.FromRows(
        {
            {456, 30, "Female", "Intermediate", "High", "Good", "Yes", "Well organized content", #date(2023,3,1), #date(2023,3,10), 5, 8},
            {457, 52, "Male", "Expert...