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