Forum Discussion

scoobymoo's avatar
scoobymoo
Frequent Visitor
8 years ago
Solved

Splitting multiple columns using delimiter

Hi   I have a table which includes 3 columns with delimiters. I need to split the columns into rows using the delimiters but maintaining the order of the information in the columns   for example:...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi scoobymoo,

     

    Based on my test, it's difficult to insert values from one column to another column in power bi. I woud recommend you to try R script or python script to do this.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi scoobymoo,

 

Based on my test, it's difficult to insert values from one column to another column in power bi. I woud recommend you to try R script or python script to do this.

 

Regards,

Jimmy Tao