Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transform data in Power Query

Dear all, I would like to ask your help on my issue. I have a data as attached with column "Value" contains 3 groups of data "Product", "Owner", "Size". Please your help to advise if it's possible ...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    I have attached the file with the transformation.

    You can download the file: HERE



     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

     



ziying35's avatar
ziying35
Icon for Impactful Individual rankImpactful Individual
6 years ago

Hi, Anonymous 

Can you post sample data? Don't post pictures, it's too tiring to hit the keyboard in light of them, this case is easy to solve

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ziying35,

     

    I'd like to add the sample data as below. Please advise the solution.

     

    Thanks for your support!

     

    Original data:

    MonthWeekValue
    JanW1Table
    JanW1Jack
    JanW1Small
    JanW1Chair
    JanW1Joe
    JanW1Large
    JanW2Chair
    JanW2Carol
    JanW2Small
    FebW5Table
    FebW5Jessica
    FebW5Large
    MarW9Table
    MarW9Marry
    MarW9Small
    MarW10Chair
    MarW10Jack
    MarW10Large