Display data based on cell elements from one column

Hi 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.