I have two data sets for a set of properties across two different years:

Here is a link to the data sets if helpful: Link to Example Datasets

I want to make a pivot table (or any kind of table that works) that compares the different Type fields across the two years for each property. It would look something like this:

I know I could so something like rename each column PropertyA Year 1, Property B Year 1, etc, but I would prefer not to do this because I’m using the tables elsewhere where this naming convention is not desirable.

How can I achieve the desired table from these two data sets?

Thank you!
Kim