I have a table of raw financial data telling me what the value of an account was at the end of a given month (denoted in the date format `MM/1/YY` to normalize). There are multiple years worth of data in this table such that I may have something like this (please ignore the exact values, they are just placeholder):

```
1/1/18  $123
2/1/18  $21
3/1/18  $34
4/1/18  $45
5/1/18  $76
6/1/18  $1
7/1/18  $123
8/1/18  $4343
9/1/18  $2
10/1/18 $53
11/1/18 $123
12/1/18 $12
1/1/19  $213
2/1/19  $123
3/1/19  $34
4/1/19  $123

```

I'd like to create an array (or ideally a pivot) using this data such that it will summarize what the last value in a given year was, including partial years.

So for the above, it would output:

```
12/1/18 $12
4/1/19 $123

```

Or even better...do the cleaning up of formatting to change it to just the full year:

```
2018 $12
2019 $123

```

When I attempt to pivot the raw data, none of the "Summarize By" options seem to result in the desired output.

The raw data table is expected to grow in length over time, so the ideal solution stays current without needing manual updates. Thus, as the table grew to 2020, it would just add that more recent month's value from that year to the end of the output.