Expand Multiple Values in list as One Row

[619SK]

I am sourcing data from Sharepoint list where  column as below. In power query where i expand data it trnasform into two rows with Owner as A & another row with Owner as B.

I want to expand list where owner show as A,B.

Company	Id	Location	Owner
XYZ	12	India	A,B

[Anonymous]

Hi,@619SK. Hello,@danextian ,thanks for your concern about this issue.
I would like to share some additional solutions below.

I am glad to help you.

According to your description, your original data looks like this.

Do you want to display the data separately based on the values in the Owner column, like this?

If my understanding is correct, then you can refer to my test below. (Using "Unpivot Columns")
1. Select the "Owner" column, in the Transform window > Split Column > By Delimiter
Split Owner into two columns by comma.

like this:

2. Select both A and B two owner columns, select "Unpivot Column"

like this

Finally, delete the Attribute column.

The final result:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[619SK]

No Its other way,

End result should contain A,B in single row only.
But when i expand it create two rows with A & B

[Ashish_Mathur · Accepted solution]

Hi,

In The Query Editor, you will have to use the Text.Combine function within the Table.Group function.  To receive further help, share some data to work with and show the expected result.

[619SK]

Not having extract  option, getting option as Expand & Aggregate.

[danextian]

Hi @619SK ,

Apply "Extract values from list" to the column.