Forum Discussion
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...
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)
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