Get values in row and sum

I have a datatable where I am trying to get the sum of the values that are between the stores. The stores begin with # . If there are more than 1 value for the store those values must be added. E.g.
#1001
80
90
#1002
10
#1003
24

I need the values to be:
#1001 170
#1002 10
#1003 24

Hi,

Hope the following sample helps you.

Sample20210602-1.zip (3.0 KB)

Regards,

Hi @Yoichi,

Works perfectly!! Thank you!!

1 Like

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