Spreadsheet: 867246d1714093036-advice-creating-a-list-using-data-from-2-separate-files-mrexcel-worksheet-longissimus-
Sheet: Query1

Month | Landing Page URL | Team ID | Location ID | Design ID | Visits | Number of purchases | Number of People who started registering | Number of ppl who finished registering
March | www.bestfootball.com | 1 | 99 | 1000 | 4343243 | 233 | 23432 | 4343
March | www.bestfootball.com | 1 | 66 | 1000 | 23432523 | 43 | 23423 | 432 |  |  |  |  |  | Values | Month
March | www.bestfootball.com | 2 | 98 | 1000 | 4534543 | 234 | 45654 | 2532 |  |  |  |  |  | Sum of Visits |  |  | Sum of Number of purchases |  |  | Sum of Number of People who started registering |  |  | Sum of Number of ppl who finished registering |  |  | Total Sum of Visits | Total Sum of Number of purchases | Total Sum of Number of People who started registering | Total Sum of Number of ppl who finished registering
March | www.cheesecake.com | 1 | 97 | 2000 | 345213 | 78 | 43534 | 354 |  | Landing Page URL | Team ID | Location ID | Design ID | February | March | April | February | March | April | February | March | April | February | March | April
March | www.cheesecake.com | 2 | 700 | 2000 | 1312312 | 80 | 235 | 200 |  | www.bacon.com | 1 | 33 | 999 |  | 900000 |  |  | 20 |  |  | 1000 |  |  | 100 |  | 900000 | 20 | 1000 | 100
March | www.cheesecake.com | 3 | 800 | 2000 | 23432432 | 3 | 43643 | 24 |  | www.bacon.com | 1 | 44 | 999 |  | 900000 |  |  | 20 |  |  | 1000 |  |  | 100 |  | 900000 | 20 | 1000 | 100
March | www.cheesecake.com | 3 | 900 | 2000 | 32432423 | 34 | 34634 | 3543 |  | www.bacon.com | 4 | 22 | 999 |  | 800000 |  |  | 20 |  |  | 1000 |  |  | 100 |  | 800000 | 20 | 1000 | 100
March | www.bacon.com | 1 | 44 | 999 | 900000 | 20 | 1000 | 100 |  | www.bestfootball.com | 1 | 66 | 1000 |  | 23432523 |  |  | 43 |  |  | 23423 |  |  | 432 |  | 23432523 | 43 | 23423 | 432
March | www.bacon.com | 1 | 33 | 999 | 900000 | 20 | 1000 | 100 |  | www.bestfootball.com | 1 | 99 | 1000 | 333333 | 4343243 | 888888 | 50 | 233 | 49 | 2000 | 23432 | 200 | 500 | 4343 | 50 | 5565464 | 332 | 25632 | 4893
March | www.bacon.com | 4 | 22 | 999 | 800000 | 20 | 1000 | 100 |  | www.bestfootball.com | 2 | 98 | 1000 | 555555 | 4534543 | 999999 | 70 | 234 | 69 | 20007 | 45654 | 2000 | 700 | 2532 | 70 | 6090097 | 373 | 67661 | 3302
February | www.bestfootball.com | 1 | 99 | 1000 | 333333 | 50 | 2000 | 500 |  | www.cheesecake.com | 1 | 97 | 2000 |  | 345213 |  |  | 78 |  |  | 43534 |  |  | 354 |  | 345213 | 78 | 43534 | 354
February | www.bestfootball.com | 2 | 98 | 1000 | 555555 | 70 | 20007 | 700 |  | www.cheesecake.com | 1 | 99 | 2000 | 3333343 |  | 3333343 | 90 |  | 89 | 20008 |  | 2000 | 899 |  | 89 | 6666686 | 179 | 22008 | 988
February | www.cheesecake.com | 1 | 99 | 2000 | 3333343 | 90 | 20008 | 899 |  | www.cheesecake.com | 2 | 97 | 2000 | 3424322 |  | 6666666 | 60 |  | 59 | 20008 |  | 2000 | 900 |  | 90 | 10090988 | 119 | 22008 | 990
February | www.cheesecake.com | 2 | 97 | 2000 | 3424322 | 60 | 20008 | 900 |  | www.cheesecake.com | 2 | 700 | 2000 |  | 1312312 |  |  | 80 |  |  | 235 |  |  | 200 |  | 1312312 | 80 | 235 | 200
February | www.cheesecake.com | 3 | 700 | 2000 | 3443545 | 30 | 2000 | 190 |  | www.cheesecake.com | 3 | 90 | 2000 |  |  | 7777777 |  |  | 29 |  |  | 200 |  |  | 19 | 7777777 | 29 | 200 | 19
February | www.cheesecake.com | 3 | 800 | 2000 | 23445555 | 20 | 2000 | 190 |  | www.cheesecake.com | 3 | 700 | 2000 | 3443545 |  |  | 30 |  |  | 2000 |  |  | 190 |  |  | 3443545 | 30 | 2000 | 190
February | www.smartphone.com | 1 | 99 | 3000 | 88888 | 12 | 200 | 100 |  | www.cheesecake.com | 3 | 800 | 2000 | 23445555 | 23432432 |  | 20 | 3 |  | 2000 | 43643 |  | 190 | 24 |  | 46877987 | 23 | 45643 | 214
February | www.smartphone.com | 2 | 66 | 3000 | 888881 | 12 | 200 | 100 |  | www.cheesecake.com | 3 | 900 | 2000 |  | 32432423 | 8864353 |  | 34 | 19 |  | 34634 | 200 |  | 3543 | 19 | 41296776 | 53 | 34834 | 3562
April | www.bestfootball.com | 1 | 99 | 1000 | 888888 | 49 | 200 | 50 |  | www.junglejoy.com | 1 | 11 | 4000 |  |  | 9090909 |  |  | 29 |  |  | 200 |  |  | 19 | 9090909 | 29 | 200 | 19
April | www.bestfootball.com | 2 | 98 | 1000 | 999999 | 69 | 2000 | 70 |  | www.smartphone.com | 1 | 99 | 3000 | 88888 |  | 9090909 | 12 |  | 11 | 200 |  | 20 | 100 |  | 10 | 9179797 | 23 | 220 | 110
April | www.cheesecake.com | 1 | 99 | 2000 | 3333343 | 89 | 2000 | 89 |  | www.smartphone.com | 2 | 66 | 3000 | 888881 |  | 9000099 | 12 |  | 11 | 200 |  | 20 | 100 |  | 10 | 9888980 | 23 | 220 | 110
April | www.cheesecake.com | 2 | 97 | 2000 | 6666666 | 59 | 2000 | 90 |  | Grand Total |  |  |  | 35513422 | 92432689 | 55712943 | 344 | 765 | 365 | 66423 | 217555 | 6840 | 3579 | 11728 | 376 | 183659054 | 1474 | 290818 | 15683
April | www.cheesecake.com | 3 | 90 | 2000 | 7777777 | 29 | 200 | 19
April | www.cheesecake.com | 3 | 900 | 2000 | 8864353 | 19 | 200 | 19
April | www.smartphone.com | 1 | 99 | 3000 | 9090909 | 11 | 20 | 10
April | www.smartphone.com | 2 | 66 | 3000 | 9000099 | 11 | 20 | 10
April | www.junglejoy.com | 1 | 11 | 4000 | 9090909 | 29 | 200 | 19