Spreadsheet: 881960d1730208336-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
Pr1 | TSHIRT | 1 | 32.99 |  |  |  |  |  |  |  |  |  |  |  | Pr2 | TSHIRT | 8 | 553.11 | Pr2 | SOCKS | 1 | 51.47
Pr2 | DRESS | 1 | 31.63 |  |  |  |  |  |  |  |  |  |  |  | Pr10 | DRESS | 2 | 140.02 | Pr4 | TSHIRT | 1 | 60.12
Pr3 | [NAME] | 1 | 11.81 |  |  |  |  |  |  |  |  |  |  |  | Pr4 | [NAME] | 4 | 189 | Pr7 | DRESS | 2 | 139.27
Pr4 | SOCKS | 2 | 3.13 |  |  |  |  |  |  |  |  |  |  |  | Pr3 | SOCKS | 1 | 47.46 | Pr6 | SOCKS | 1 | 52.21
Pr5 | SHOES | 2 | 1.73 |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  | Total
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr E |  |  |  | [NAME]: Mr E
Customer Code:[PHONE] Name: Mr B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pr3 | [NAME] | 6 | 205.67 | Pr1 | TSHIRT | 2 | 69.4
Pr6 | TSHIRT | 2 | 60.28 |  |  |  |  |  |  |  |  |  |  |  | Pr8 | SOCKS | 3 | 141.69 | Pr8 | DRESS | 7 | 325.59
Pr7 | SHOES | 1 | 26.84 |  |  |  |  |  |  |  |  |  |  |  | Pr7 | TSHIRT | 6 | 10.2 | Pr7 | [NAME] | 3 | 116.71
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pr1 | SHOES | 6 | 11.4 | Total
Customer Code:[PHONE] Name: Mr C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Pr5 | SOCKS | 2 | 60.41 |  |  |  |  |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr B
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pr6 | TSHIRT | 2 | 60.28
Customer Code:[PHONE] Name: Mr D |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr D |  |  |  |  |  |  | Pr7 | SHOES | 1 | 26.84
Pr4 | TSHIRT | 1 | 24.4 |  |  |  |  | Pr4 | SOCKS | 3 | 103.2 |  |  |  | Total
Pr6 | [NAME] | 2 | 62.62 |  |  |  |  | Pr7 | SHOES | 3 | 102.33 |  |  |  | Customer Code:[PHONE] Name: Mr D |  |  |  | Customer Code:[PHONE] Name: Mr D
Total |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | Pr4 | TSHIRT | 1 | 24.4 | Pr4 | SOCKS | 3 | 103.2
Customer Code:[PHONE] Name: Mr E |  |  |  |  |  |  |  | [NAME]: Mr E |  |  |  |  |  |  | Pr6 | [NAME] | 2 | 62.62 | Pr7 | SHOES | 3 | 102.33
Pr3 | [NAME] | 6 | 205.67 |  |  |  |  | Pr1 | TSHIRT | 2 | 69.4 |  |  |  | Total |  |  |  | Total
Pr8 | SOCKS | 3 | 141.69 |  |  |  |  | Pr8 | DRESS | 7 | 325.59 |  |  |  | Customer Code:[PHONE] Name: Mr A
Pr7 | TSHIRT | 6 | 10.2 |  |  |  |  | Pr7 | [NAME] | 3 | 116.71 |  |  |  | Pr1 | TSHIRT | 1 | 32.99
Pr1 | SHOES | 6 | 11.4 |  |  |  |  | Total |  |  |  |  |  |  | Pr2 | DRESS | 1 | 31.63
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pr3 | [NAME] | 1 | 11.81
Customer Code:[PHONE] Name: Mr F |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr F |  |  |  |  |  |  | Pr4 | SOCKS | 2 | 3.13
Pr2 | TSHIRT | 8 | 553.11 |  |  |  |  | Pr2 | SOCKS | 1 | 51.47 |  |  |  | Pr5 | SHOES | 2 | 1.73
Pr10 | DRESS | 2 | 140.02 |  |  |  |  | Pr4 | TSHIRT | 1 | 60.12 |  |  |  | Total
Pr4 | [NAME] | 4 | 189 |  |  |  |  | Pr7 | DRESS | 2 | 139.27 |  |  |  | Customer Code:[PHONE] Name: Mr C
Pr3 | SOCKS | 1 | 47.46 |  |  |  |  | Pr6 | SOCKS | 1 | 52.21 |  |  |  | Pr5 | SOCKS | 2 | 60.41
Total |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr H |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr I |  |  |  | Customer Code:[PHONE] Name: Mr I
 |  |  |  |  |  |  |  | Pr5 | TSHIRT | 1 | 34.05 |  |  |  | Pr5 | DRESS | 1 | 33.29 | Pr1 | DRESS | 2 | 27.89
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | Pr2 | TSHIRT | 2 | 14.42 | Total
Customer Code:[PHONE] Name: Mr I |  |  |  |  |  |  |  | Customer Code:[PHONE] Name: Mr I |  |  |  |  |  |  | Total
Pr5 | DRESS | 1 | 33.29 |  |  |  |  | Pr1 | DRESS | 2 | 27.89
Pr2 | TSHIRT | 2 | 14.42 |  |  |  |  | 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.
Total