Compare 2 different lists and create a new table with the data

Hello everybody, I am new here. I have 2 lists representing data from my company, which more specifically are for the years 2023 and 2024 the sold items per customer, alongside with the quantity of items purchased and the total price. What i want, is to compare those 2 lists and create a new list or table with data from both lists, in ascending order with the highest value purchased from each customer. I will attach a test file i created which is very similar to my data. Really looking forward to an answer.

test.xlsx