Expand Feature – Ability to choose ‘how’ to expand a record or a table within a column (in Power Query) such as the following • Show drop down choice to expand into new rows (as it currently does) OR expand back into the cell as a comma separated value (which shows all readable text, not just a record) Scenario – I have a SharePoint list with 14 records and a field on a given record contains a list of items that are separated by a comma. When the data is imported into Power Query, the data shows Actual Results – A record or table. Once I expand the column, I get new rows to account for every single instance of the data within the comma separated field (i.e. now showing 50, 653 rows) Expected Result – The cell contains text that is simply separated by a comma and not transformed into a record **Note: The ‘Group By’ function only allows me to group the columns back into a Record or Table
... View more