Transform single row into multiple rows based on a cell value

[Anonymous]

How do you transform rows into multiple rows like on the picture?

[AnthonyTilley · Accepted solution]

in power bi desktop go to EDIT QUERIES

in the query editor right click the Fruits colunm and select split colunm 

in the menue select split by delimiter

in the pop up select the following Custom from teh drop down 

in the box provided enter +

Split at "Each occurrense of the Delimiter

Click Advanced options

select split into Rows

and in Qoute Charated select None

Click Okay and your data source shoult now be as requested 

[Anonymous]

Thanks @AnthonyTilley worked perfectly!

[Zubair_Muhammad]

@Anonymous 

From the Query Editor,  add this custom column, then expand it to new rows

=Text.Split([Fruits Purchase],"+")