Group by column

Hello everyone!
I have DT with 400 row
The fifth column - “city”
Now I need fill in app: 1 row in app - all city “a” in my DT
For example row “city”:
a
a
a
a
d
d
d
d
d
g
f
f
f
f
b
b
n
n
n
n
n
m
m
m
m
m
m
c
c
c
r
r
r
r
a
a

I need group city by common city
and also fill in app, but for each city “a” in DT I have different district
I need fill from city
a
b
c
r
And then FOR EACH city fill districts
How I can do it?

@RPA3 - you can try below -

DtUnique =DT.DefaultView.ToTable(True,“City”)

1 Like