I know you are asking for a Beast Mode solution but I hope this is helpful to consider.

One way to do this is to Unpivot your data, then use a beast mode for each year as a column in a pivot table.

Your columns would end up being along the lines of: Metric Label, 2022, 2023

2022 defined as:

CASE WHEN YEAR(`Date`) = '2022' then `Value` else 0 end

2023 defined as:

CASE WHEN YEAR(`Date`) = '2022' then `Value` else 0 end

You'd end up with a table very similar to what you show in your example, and with some tweaking on the coloring and heading rows would likely satisfy the requirement.