Is there a way to write a query for Custom Column in Power BI to use value from one column as column name?

Something like:

T1 = [Position] 
Table.AddColumn(#"Added custom 3", "Total", each [T1])

I have an issue with combining Excel files in Power BI which have different format:

I want to

1. Load all files together (there will multiple files from multiple years)
2. Get the total column per file (Broken by Year would be a bonus)

I was able to transform the data to get column with total per file:

Can I write a Custom Query which will pick up the value from the helper table and use that value as column name?