Forum Discussion

rshifflet's avatar
rshifflet
Frequent Visitor
9 years ago
Solved

Delimitate Column into Single Column

This may be a very simple thing, so please excuse my ignorance. I will try and articulate this the best that I can. When I go to edit my quiries, I have several columns with values that are comma del...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

     

    According  to your description, you want to spilt the “LSR’s “ column by “,” and merge them to one column, right?

     

    If as I said, you can follow below steps:

     

    Source table:


     

    1. Open the edit query and duplicate the base table:

     


     

    2. Right-Click on LSR’s and choose the “spilt column” -> “By Delimiter”:


     

     

     

     

    3.All select the columns and choose the “Unpivot Columns”:
     

     

     

    4.Modify the formula of "Unpivot Columns":

     

    Table.UnpivotOtherColumns(#"Changed Type1", {}, "Attribute", "Value")[Value]

     


     

    5. Close and apply the change, then create a visual.

     


     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

 

According  to your description, you want to spilt the “LSR’s “ column by “,” and merge them to one column, right?

 

If as I said, you can follow below steps:

 

Source table:


 

1. Open the edit query and duplicate the base table:

 


 

2. Right-Click on LSR’s and choose the “spilt column” -> “By Delimiter”:


 

 

 

 

3.All select the columns and choose the “Unpivot Columns”:
 

 

 

4.Modify the formula of "Unpivot Columns":

 

Table.UnpivotOtherColumns(#"Changed Type1", {}, "Attribute", "Value")[Value]

 


 

5. Close and apply the change, then create a visual.

 


 

Regards,
Xiaoxin Sheng

rshifflet's avatar
rshifflet
Frequent Visitor
9 years ago

Xiaoxin_Sheng,

 

Thank you so much for your solution. It is exactly what I was looking for.