Forum Discussion

Jukie's avatar
Jukie
Frequent Visitor
2 years ago
Solved

Unpivot Columns in Groups

Hello! I have a Sharepoint List collecting data from a Power App Form.  For end user ease, they can enter multiple expenses on one form.  However, this adds all the different expenses to one row on m...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Jukie 

    maybe you can try this

    merge same group of column

     

     

    select the first two columns and unpivot other columns

     

     

    remove the attribute column and split value column by delimiter

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

Jukie 

maybe you can try this

merge same group of column

 

 

select the first two columns and unpivot other columns

 

 

remove the attribute column and split value column by delimiter

Jukie's avatar
Jukie
Frequent Visitor
2 years ago

ryan_mayu  Exactly the result I was hoping to get.  Thank you for taking the time to think this over and provide an answer.  The images and detailed directions are super helpful.  THANKS!

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    you are welcome