Forum Discussion
Need help with power query unpivoting
Community SupportHi kamranmumtaz02 ,
According to your description, I try my best to reproduce your problem. I create sampe like this:
Here's my solution.
1.Add a custom column in MACHINE1, MACHINE2, MACHINE3 tables separately like this:
2.Select Merge Queries>Merge Queries as New.
3.Filter out the blank and title rows.
Get the result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-kal
Thank you for your efforts but the provided data is sample data, there are more than 15 machines, and I cannot make them table each time, which is why I asked if is there a way to make the complete data a table and then convert it into one data. I am new to power query but can make one data from multiple sheets, but this is something challenging for me.