Sum colums based on column names

[oliviercz]

Hi all,

I would like to sum all the columns from the same year, but i don't really know how to tackle this.

My input is:

And my desired output is:

What tool should I use to do this?

Thanks!!

 

[afv2688 · Accepted solution]

Hello @oliviercz ,

How about this?

Regards

[oliviercz]

Thanks a lot, I didn't know about the RegEx tool