cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dorothybl Frequent Visitor
Frequent Visitor

Transform single row into multiple rows based on a cell value

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

2019-04-15_14-43-36.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Transform single row into multiple rows based on a cell value

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 3
Super User
Super User

Re: Transform single row into multiple rows based on a cell value

@dorothybl 

 

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

 

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

Re: Transform single row into multiple rows based on a cell value

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 

 

 

 

dorothybl Frequent Visitor
Frequent Visitor

Re: Transform single row into multiple rows based on a cell value

Thanks @AnthonyTilley worked perfectly!