Forum Discussion
Transform single row into multiple rows based on a cell value
How do you transform rows into multiple rows like on the picture?
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
3 Replies
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
Thanks AnthonyTilley worked perfectly!
Anonymous
From the Query Editor, add this custom column, then expand it to new rows
=Text.Split([Fruits Purchase],"+")
