Forum Discussion

BrendonHerbert's avatar
BrendonHerbert
Regular Visitor
6 years ago
Solved

Remodel Sharepoint data

Hi   I have a Sharepoint list containing weekly status updates for a project with multiple releases which in turn have multiple streams.   The form in Sharepoint is just one big form asking for i...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi BrendonHerbert 

    Select "Scope RAG" column till the end "Deliverable Due" column, select "unpovot columns",

    Then split "Attribute" column by delimiter space,

    Select "Attribute.1" column and pivot column

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi BrendonHerbert 

Select "Scope RAG" column till the end "Deliverable Due" column, select "unpovot columns",

Then split "Attribute" column by delimiter space,

Select "Attribute.1" column and pivot column

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • BrendonHerbert's avatar
    BrendonHerbert
    Regular Visitor
    6 years ago
    Maggie!! That worked perfectly.

    Thank you very much