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 appriciate...
Need Help
Show and Tell
Tips and Tricks
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