How to distinct count the row value?

[saranp780]

My objective is, I want to verify some asset from my user. So I have to run some script that contains the hardware information such as below.

EmID	Name	LastName	Asset	CPU	GPU	Monitor	S/w
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	1
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	2
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	3
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	4
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	5
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	6
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	7
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	8
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	9
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	10
B3480	Eligah	Jackson	34001	Intel Core i5-9400	Intel UHD630	LG 27"	11
A3350	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	1
A3351	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	2
A3352	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	3
A3353	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	4
A3354	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	5
A3355	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	6
A3356	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	7
A3357	Tomas	Johnson	35001	Intel Core i5-9400	Intel UHD630	HP 19"	8
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	1
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	2
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	3
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	4
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	5
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	6
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	7
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	8
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	9
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	10
B3480	Eligah	Jackson	34001	Intel Core i5-9400	nVidia Geforce GTX  1650	LG 27"	11

From this example the result that I get is "1" and the result only show "

B3480

Eligah

Jackson

34001

Intel Core i5-9400

nVidia Geforce GTX  1650

LG 27"

PS. This information will be shown software as a unique name but I can't delete or remove them because in some report I have to count them also.

[v-yuaj-msft]

Hi @saranp780 ,

I'm sorry for that it's still not very clear. Is this your desired result?

If not, please provide me with your expected results. It couldn't be better if you kindly offer me a form or a screenshot.

Best Regards,

Yuna

[camargos88]

@saranp780 ,

Can you please explain a little bit more what you are trying to achieve ??

Some example as output would be help.

[saranp780]

I would like to get some result that counts the different hardware from the example above =1 and showing the name of data different = 

B3480

Eligah

Jackson

34001

Intel Core i5-9400

nVidia Geforce GTX  1650

LG 27

but no show of the data that unchange.