Display data based on cell elements from one column

[user_bi]

Hello, 

I have a dataset that has 8 columns 

below is the sample data :

code	MATRIXCDE	MATRIX	MATRIX_DESC	SUBGROUP	SUBGROUPNAME	PARAMETERCODE	PARAMETERNAME	TESTMETHOD
100	1675	ADM	Admixture	Admixture (Civil)	Chemical	P123	xyz	site
100	1544	ADM	Admixture	Chemical	Chemical	P124	ghj	Visual
100	1675	ADM	Admixture	Admixture (Civil)	Chemical	P125	lkj	Visual
100	1	AIR	Air	MONITORING	Monitoring	P126	kl	Digital Meter
100	1	AIR	Air	MONITORING	Monitoring	P127	cl	Visual
100	1	AIR	Air	MONITORING	Monitoring	P128	cl	site
100	2849	ANF	ANIMAL FEED	METALS	Monitoring	P129	zn	Digital Meter
100	2849	ANF	ANIMAL FEED	METALS	METALS	P130	zn	Visual
100	2847	ANF	ANIMAL FEED	SUGAR PROFILE	SUGAR PROFILE	P131	fr	Visual

i want the data to be displayed for each MATRIX_DESC one after the other:

Admixture

PARAMETERCODE	PARAMETERNAME	TESTMETHOD
P123	xyz	site
P124	ghj	Visual
P125	lkj	Visual

AIR

PARAMETERCODE	PARAMETERNAME	TESTMETHOD
P126	kl	Digital Meter
P127	cl	Visual
P128	cl	site

ANIMAL FEED

PARAMETERCODE	PARAMETERNAME	TESTMETHOD
P129	zn	Digital Meter
P130	zn	Visual
P131	fr	Visual

How  can i achieve this format ? i have tried grouping the data by MATRIX_DESC but still cant display it. 

[v-weiyan1-msft]

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.

[user_bi]

Hi @v-weiyan1-msft 

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