Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
amalrio
Helper V
Helper V

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

 

NewtabelRequirment.PNG 

7 REPLIES 7
v-robertq-msft
Community Support
Community Support

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.

edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

PaulDBrown
Community Champion
Community Champion

@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)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

amitchandak
Super User
Super User

@amalrio , need to check with M experts

@ImkeF , @edhans , can you please help on this.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks a lot @amitchandak 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.