Forum Discussion
Display data based on cell elements from one column
Community SupportHi user_bi ,
Based on the sample and description you provided, Please try the following steps:
1.In the Power Query Editor，click on 'Group By' on the Transform tab.
2. Please Right-click on the table cell and select Add as New Query. You can rename the new query as needed.
Next you can remove unnecessary columns as needed.
Result is as below.
In addition， you can also consider using the dax as follows.
AdmixtureTable = FILTER('Table2','Table2'[MATRIX_DESC] = "Admixture")Result is as below.
For further details，please find attachment.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This sample contains only 3 different Matrix_desc but the original dataset has 200+, is there a better way to execute the above for 200+ parameters as grouping them individually would be very time consuming.
Thank you in advance
