Forum Discussion

amalrio's avatar
amalrio
Helper V
5 years ago

transform excel table

Hi,

 

I have a excel tabel like below and i want to output as in the image. both of them are on the same image.

I would like to know the PowerQuery transformation.

 

any help would be appriciated

 

 

Need Help
Show and Tell
Tips and Tricks

7 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    amalrio 

    Any chance you can provide  sample data (pivot table) in a file? (you can upload to a cloud service such as Onedrive, Google Drive, Dropbox...and share the file from there)

    • amalrio's avatar
      amalrio
      Helper V
      5 years ago

      thanks a lot for the reply, unfortunatly I cannot put files into the google drive, if you can provide me your email, I can email them to you.

      thanks a lot for your help.

      Charity

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    You are going to have to provide sample data amalrio - I cannot type that in. See links below.

     

    How to get good help fast. Help us help you.
    How to Get Your Question Answered Quickly - Give us a good and concise explanation
    How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

    • amalrio's avatar
      amalrio
      Helper V
      5 years ago

      There @edhans ,

      thanks a lot for the reply, unfortunatly I cannot put files into the google drive, if you can provide me your email, I can email them to you.

      thanks a lot for your help.

      Charity

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    Hi, amalrio 

    According to your picture, if you want to get the help with Power query, I suggest you to go to the Power query forum to ask for help so that more experts in the Power query can help you in advance.

    What's more, I think the sample data in Excel or table form is also needed.

    Thanks very much!

    How to Get Your Question Answered Quickly 

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.