Forum Discussion
Remodeling data from excel (VeeamOne extract)
Thank you WishAskedSooner
Hi, Pingouin_Puni
Based on your source data, I made a sample data as follows:
First, I will prepare the following table:
Perform a merge operation on Table1 in PowerQuery:
Finally, remove the rows where value is empty to get the output you expect:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is a job for PowerQuery whether in Excel or PowerBI. Hard to say exactly what the PowerQuery M code would look like without an actual example or mock up of the data, but it shouldn't be too hard. Or, maybe a power user here can post a quick solution.