Total by year. Values in 2 columns

[Johnny1981]

Hi, I have a table like this, where the amounts are divided into 2 diferents columns. 

First Payment	Year 1° Payment	Second Payment	Year 2° Payment
$ 43.499,00	2013	$ 43.501,00	2013
$ 73.140,00	2013	$ 73.141,00	2013
$ 87.686,00	2013	$ 87.687,00	2013
$ 83.064,00	2013	$ 83.064,00	2013
$ 75.875,00	2013	$ 75.875,00	2013
$86.500,00	2013	$ 86.500,00	2013
$ 74.027,00	2013	$ 74.027,00	2013
$ 90.725,00	2013	$ 90.726,00	2013
$ 65.197,00	2013	$ 65.197,00	2013
$ 65.404,00	2013	$ 65.404,00	2013
$ 80.000,00	2013	$ 80.000,00	2013
$ 235.000,00	2014	$ 235.000,00	2014
$ 205.000,00	2014	$ 205.000,00	2014

I wanna get the total by year

Year	Total Payment
2013	$       1.650.239
2014	$          880.000

Thanks !!

[MattAllington]

Reshape you’re table in power query before you load it.  Set it up as 

paymentyear, payment number, amount

then it is eaSy

---

[Johnny1981]

Thank you very much for your answer. The table in my example is only part of a very large table, in which I cannot make the change you say. The table has one row for each company.