Community Center | Not monitored
Tag not monitored by Microsoft.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I need to expand the list (Guid no:6) in the below picture which consists of 2 values in Power bi power query Editor


Data inside the list:
Is there any way to expand the list of 2 values into 2 separate rows with the same key value?
For Eg:
Input:
1->A
2->[B,C]
Expected Output:
1->A
2->B
2->C
Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/
--please don't forget to upvote and
if the reply is helpful--