Expand list to separate column in Power Bi query editor

Anto Reni Huxley Antokinsley 81 Reputation points
2021-11-05T11:44:07.993+00:00

I need to expand the list (Guid no:6) in the below picture which consists of 2 values in Power bi power query Editor
146865-image.png

146873-image.png

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

Community Center | Not monitored
0 comments No comments
{count} votes

Answer accepted by question author
  1. Anonymous
    2021-11-05T12:52:53.39+00:00

    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 145510-image.png if the reply is helpful--

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.