How to rows count by per value?

Help Activities
, ,
1

Hi,

I have a data like this :

image
image1006×521 152 KB

If I count the data table (dt_tmp.rows.count.tostring) the value will be 11.

Can I read the datatable like this :
Mazda : 4
Honda : 4
Mercedes : 2
Hyundai : 1

Any possibility?

2

Hi @Rhys18 ,
Of course possible. Try this.
Book3.xlsx (8.8 KB)

Sequence.xaml (8.6 KB)

3

Thank you very much !

4

u’re welcome

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.