Multi-Value SharePoint Fields

[itahir04]

Hi Community.

I have a share point list with two coloumns that have multiple values.

Example

College	Major
NJIT; NYU; DPS	Chem;Bio
FSU; UCLA	Chem;Bio;CS

When I bring this data in Power BI, each cell contains  “List Value”

College	Major
List Value	List Value
List Value	List Value

How do I bring the correct field values splitted in rows.

My Coloumn doesn't give options “Expand to New Rows” or “Extract Value”.

Please help I am new to Power BI.

Thanks,

Rana

[amitchandak · Accepted solution]

@itahir04 , You have to try split by Delimiter Twice(once for each column), and then you might to use remove duplicate in power query

Split Column Power Query: https://youtu.be/FyO9Vmhcfag