Spreadsheet: 882242d1730519822-compare-2-different-lists-and-create-a-new-table-with-the-data-test
Sheet: Sheet1

 |  | 2023 |  |  |  |  |  |  |  | 2024 |  |  |  |  |  |  | RESULT: COMPARISON 2023-2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 |  |  |  | 2024
 |  | Customer Code:[PHONE] Name: Mr A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr F |  |  |  | Customer Code:[PHONE] Name: Mr F
2023 | 1 | Pr1 | TSHIRT | 1 | 32.99 |  |  | 2024 |  |  |  |  |  |  |  |  | Pr2 | TSHIRT | 8 | 553.11 | Pr2 | SOCKS | 1 | 51.47
2023 | 1 | Pr2 | DRESS | 1 | 31.63 |  |  | 2024 |  |  |  |  |  |  |  |  | Pr10 | DRESS | 2 | 140.02 | Pr4 | TSHIRT | 1 | 60.12
2023 | 1 | Pr3 | [NAME] | 1 | 11.81 |  |  | 2024 |  |  |  |  |  |  |  |  | Pr4 | [NAME] | 4 | 189 | Pr7 | DRESS | 2 | 139.27
2023 | 1 | Pr4 | SOCKS | 2 | 3.13 |  |  | 2024 |  |  |  |  |  |  |  |  | Pr3 | SOCKS | 1 | 47.46 | Pr6 | SOCKS | 1 | 52.21
2023 | 1 | Pr5 | SHOES | 2 | 1.73 |  |  | 2024 |  |  |  |  |  |  |  |  | Total |  |  |  | Total
2023 |  | Total |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr E |  |  |  | [NAME]: Mr E
2023 |  | Customer Code:[PHONE] Name: Mr B |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  | Pr3 | [NAME] | 6 | 205.67 | Pr1 | TSHIRT | 2 | 69.4
2023 | 2 | Pr6 | TSHIRT | 2 | 60.28 |  |  | 2024 |  |  |  |  |  |  |  |  | Pr8 | SOCKS | 3 | 141.69 | Pr8 | DRESS | 7 | 325.59
2023 | 2 | Pr7 | SHOES | 1 | 26.84 |  |  | 2024 |  |  |  |  |  |  |  |  | Pr7 | TSHIRT | 6 | 10.2 | Pr7 | [NAME] | 3 | 116.71
2023 |  | Total |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  | Pr1 | SHOES | 6 | 11.4 | Total
2023 |  | Customer Code:[PHONE] Name: Mr C |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  | Total
2023 | 3 | Pr5 | SOCKS | 2 | 60.41 |  |  | 2024 |  |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr B
2023 |  | Total |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  | Pr6 | TSHIRT | 2 | 60.28
2023 |  | Customer Code:[PHONE] Name: Mr D |  |  |  |  |  | 2024 |  | Customer Code:[PHONE] Name: Mr D |  |  |  |  |  |  | Pr7 | SHOES | 1 | 26.84
2023 | 4 | Pr4 | TSHIRT | 1 | 24.4 |  |  | 2024 | 4 | Pr4 | SOCKS | 3 | 103.2 |  |  |  | Total
2023 | 4 | Pr6 | [NAME] | 2 | 62.62 |  |  | 2024 | 4 | Pr7 | SHOES | 3 | 102.33 |  |  |  | Customer Code:[PHONE] Name: Mr D |  |  |  | Customer Code:[PHONE] Name: Mr D
2023 |  | Total |  |  |  |  |  | 2024 |  | Total |  |  |  |  |  |  | Pr4 | TSHIRT | 1 | 24.4 | Pr4 | SOCKS | 3 | 103.2
2023 |  | Customer Code:[PHONE] Name: Mr E |  |  |  |  |  | 2024 |  | [NAME]: Mr E |  |  |  |  |  |  | Pr6 | [NAME] | 2 | 62.62 | Pr7 | SHOES | 3 | 102.33
2023 | 5 | Pr3 | [NAME] | 6 | 205.67 |  |  | 2024 | 5 | Pr1 | TSHIRT | 2 | 69.4 |  |  |  | Total |  |  |  | Total
2023 | 5 | Pr8 | SOCKS | 3 | 141.69 |  |  | 2024 | 5 | Pr8 | DRESS | 7 | 325.59 |  |  |  | Customer Code:[PHONE] Name: Mr A
2023 | 5 | Pr7 | TSHIRT | 6 | 10.2 |  |  | 2024 | 5 | Pr7 | [NAME] | 3 | 116.71 |  |  |  | Pr1 | TSHIRT | 1 | 32.99
2023 | 5 | Pr1 | SHOES | 6 | 11.4 |  |  | 2024 |  | Total |  |  |  |  |  |  | Pr2 | DRESS | 1 | 31.63
2023 |  | Total |  |  |  |  |  | 2024 |  |  |  |  |  |  |  |  | Pr3 | [NAME] | 1 | 11.81
2023 | 6 | Customer Code:[PHONE] Name: Mr F |  |  |  |  |  | 2024 |  | Customer Code:[PHONE] Name: Mr F |  |  |  |  |  |  | Pr4 | SOCKS | 2 | 3.13
2023 | 6 | Pr2 | TSHIRT | 8 | 553.11 |  |  | 2024 | 6 | Pr2 | SOCKS | 1 | 51.47 |  |  |  | Pr5 | SHOES | 2 | 1.73
2023 | 6 | Pr10 | DRESS | 2 | 140.02 |  |  | 2024 | 6 | Pr4 | TSHIRT | 1 | 60.12 |  |  |  | Total
2023 | 6 | Pr4 | [NAME] | 4 | 189 |  |  | 2024 | 6 | Pr7 | DRESS | 2 | 139.27 |  |  |  | Customer Code:[PHONE] Name: Mr C
2023 | 6 | Pr3 | SOCKS | 1 | 47.46 |  |  | 2024 | 6 | Pr6 | SOCKS | 1 | 52.21 |  |  |  | Pr5 | SOCKS | 2 | 60.41
2023 |  | Total |  |  |  |  |  | 2024 |  | Total |  |  |  |  |  |  | Total
2023 |  |  |  |  |  |  |  | 2024 |  | Customer Code:[PHONE] Name: Mr H |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr I |  |  |  | Customer Code:[PHONE] Name: Mr I
2023 |  |  |  |  |  |  |  | 2024 | 7 | Pr5 | TSHIRT | 1 | 34.05 |  |  |  | Pr5 | DRESS | 1 | 33.29 | Pr1 | DRESS | 2 | 27.89
2023 |  |  |  |  |  |  |  | 2024 |  | Total |  |  |  |  |  |  | Pr2 | TSHIRT | 2 | 14.42 | Total
2023 |  | Customer Code:[PHONE] Name: Mr I |  |  |  |  |  | 2024 |  | Customer Code:[PHONE] Name: Mr I |  |  |  |  |  |  | Total
2023 | 6 | Pr5 | DRESS | 1 | 33.29 |  |  | 2024 | 8 | Pr1 | DRESS | 2 | 27.89
2023 | 6 | Pr2 | TSHIRT | 2 | 14.42 |  |  | 2024 |  | Total |  |  |  |  |  |  | THE RESULT I WANT IS A COMPARISON OF BOTH LISTS LIKE THIS ONE, WITH DESCENDING/ASCENDING ORDER (BOTH ARE OK) SO THAT I CAN COMPARE THE DATA FROM BOTH YEARS. I WANT TO BE ABLE TO ALSO SEE THE QUANTITIES OF PRODUCTS PURCHASED. ALSO, FOR THE CUSTOMERS WHO DIDN’T EXIST THE 1 OF THE 2 YEARS I WANT IT TO STAY BLANK LIKE IT IS HERE.
2023 |  | Total |  |  |  |  |  | 2024