Sum numbers in one list based on duplicate text items in another list

Lists-Logic
1

Hi,
I would like to reduce the text list (in this case room names) and at the same time sum the corresponding index values in the number list (in this case areas). As per the graph extract.
Any ideas on how to do this using either nodes or would it require code?
cheers
Spencer
image

2

List.GroupByKey
Math.Sum (longest lacing).

4 Likes
3

Thanks very much Jacob :slight_smile:
For others, nodes are as per extract.
image

2 Likes