PowerQuery Sum columns?

[Netrelemo]

I have a SharePoint list with 12 columns, each column representing one calendar month. The columns have a dollar value, or null. 

Each row represents a product code, and a year. 

How do I sum the row, so that I have one dollar value, per year, per product? 

Sure I could group and explicitly code each column name, but maybe there is some magic row sum formula? 

From this

Product	Year	F1	F2	F3	F4	....	F12
X	2023	100	null	100	null		null
Y	2024	100	100	100	null		100

To this

Product	Year	Total
X	2023	700
Y	2024	900

[ryan_mayu · Accepted solution]

@Netrelemo 

1. select product and year column and unpivot other columns

2. group by