Nested "for each row"

[alessandro.rocco]

Hello,
I have a table like the one below, with a column A with repeating values, and a column B with unique value associated at the value in the column A.
for each value of column A I must perform only one action (even if this appears in the column more than once), while for each value of column B it must repeat it as many times as there are values ​​in column B

I had thought of nesting two “For Each” loops, but the problem is that the action of column A must be repeated once while that of column B must repeat itself several times.
do you have any ideas?
thank you

[ppr]

@alessandro.rocco
If we got your requirements correctly we can do it with the help of a group by

we do building groups by the distinct sub-order values and
process the corresponding order values

find starter help here:
GroupBy_IntroSample_LINQ.xaml (10.4 KB)

similar approach without LINQ
GroupBy_IntroSample_DistinctAndFilter.xaml (11.6 KB)

[alessandro.rocco]

@ppr you understand perfectly what i have to do, and your solution seems to works fine.
thank you