Expand a Record or Table within a column (using Power Query):

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