Forum Discussion
619SK
Helper II
Helper IIExpand Multiple Values in list as One Row
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 whe...
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.
619SKHelper II
Helper IINo 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
Super User
Super UserHi,
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.