Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Spliting rows with spicific columns

Hello Everyone and thank you in advance for your help, I'm struggling with this problem, here's an example:     I manage to split the rows using M but I can't find a way to make the split...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi Anonymous ,

    1. Check the column "Row" and unpivot other columns
    2. Check the resulting "Attribute"-column and extract the first 3 characters from it
    3. Pivot that new column with "Values" in the values-section

     

ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi Anonymous ,

  1. Check the column "Row" and unpivot other columns
  2. Check the resulting "Attribute"-column and extract the first 3 characters from it
  3. Pivot that new column with "Values" in the values-section

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

ImkeF 

 

I managed to make it work! I was extracting just the first 3 letters of the column instead of splitting it!

Thank you so much! This will save me a ton of time!