Forum Discussion

amien's avatar
amien
Icon for Helper V rankHelper V
10 years ago

Split Column not into columns but into rows

is this possible? i don't want to have new columns, but i want to have a new row for each split in the same column. all the other values in columns are the same as result.

1 Reply

  • pa_trick67's avatar
    pa_trick67
    Icon for Helper I rankHelper I
    6 years ago

    Hi amien 

     

    You can perform that in query editor.

    1. split column

    2. unpivot column

     

    Tell me if you need any assistance

     

    If this solves your issues, please mark it as the solution.
    Patrick