Table.ExpandListColumn

When presented with a table containing a column of values, this process involves breaking down the list into individual rows for each value. The values in the remaining columns are replicated in every new row generated.

Divide the column named [Name] in the table into separate entries. Use the Power Query function MTable.ExpandListColumn to achieve this. For instance, we can split the list of names into individual rows, each showing the corresponding discount value. After applying this function, the output will display each name with its respective discount value in separate rows.