Forum Discussion

PhoenixBird66's avatar
PhoenixBird66
Icon for Helper III rankHelper III
5 years ago
Solved

Please help -should I Pivot or Split by Delimiter?

Hi Guys,

 

I've got some data which is really messy. In some columns we have multiple values separated with a comma, and then in another column they have percentages also separated with a comma, like in the image below.

 

 

I need to be able to match up the percentage with the correct process - so for ID 1234 I need 3 lines of data:

 

Annealing is 20%

Brazing is 20% 

Canning is 60%

 

I dont know how best to do this -should I split the columns by delimiter, or should I be unpivoting them?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

    Based on your description, you can do some steps as follows.

     

     

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.