Spreadsheet: 868351d1715084958-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 | may | May1 | February | March | April | may | May1 | February | March | April | may | May1 | February | March | April | may | May1
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 |  |  |  | 888888 | 32310309 | 1888887 |  | 1888887 | 120 | 510 | 118 |  | 118 | 22007 | 92509 | 2200 |  | 2200 | 1200 | 7307 | 120 |  | 120 | 36976971 | 866 | 118916 | 8747
March | www.bacon.com | 1 | 33 | 999 | 900000 | 20 | 1000 | 100 |  | www.cheesecake.com |  |  |  | 33646765 | 57522380 | 26642139 |  | 26642139 | 200 | 195 | 196 |  | 196 | 44016 | 122046 | 4400 |  | 4400 | 2179 | 4121 | 217 |  | 217 | 144453423 | 787 | 174862 | 6734
March | www.bacon.com | 4 | 22 | 999 | 800000 | 20 | 1000 | 100 |  | www.junglejoy.com |  |  |  |  |  | 9090909 |  | 9090909 |  |  | 29 |  | 29 |  |  | 200 |  | 200 |  |  | 19 |  | 19 | 18181818 | 58 | 400 | 38
February | www.bestfootball.com | 1 | 99 | 1000 | 333333 | 50 | 2000 | 500 |  | www.smartphone.com |  |  |  | 977769 |  | 18091008 |  | 18091008 | 24 |  | 22 |  | 22 | 400 |  | 40 |  | 40 | 200 |  | 20 |  | 20 | 37159785 | 68 | 480 | 240
February | www.bestfootball.com | 2 | 98 | 1000 | 555555 | 70 | 20007 | 700 |  | (blank) | (blank) | (blank) | (blank)
February | www.cheesecake.com | 1 | 99 | 2000 | 3333343 | 90 | 20008 | 899 |  | Grand Total |  |  |  | 35513422 | 92432689 | 55712943 |  | 55712943 | 344 | 765 | 365 |  | 365 | 66423 | 217555 | 6840 |  | 6840 | 3579 | 11728 | 376 |  | 376 | 239371997 | 1839 | 297658 | 16059
February | www.cheesecake.com | 2 | 97 | 2000 | 3424322 | 60 | 20008 | 900
February | www.cheesecake.com | 3 | 700 | 2000 | 3443545 | 30 | 2000 | 190
February | www.cheesecake.com | 3 | 800 | 2000 | 23445555 | 20 | 2000 | 190
February | www.smartphone.com | 1 | 99 | 3000 | 88888 | 12 | 200 | 100
February | www.smartphone.com | 2 | 66 | 3000 | 888881 | 12 | 200 | 100
April | www.bestfootball.com | 1 | 99 | 1000 | 888888 | 49 | 200 | 50
April | www.bestfootball.com | 2 | 98 | 1000 | 999999 | 69 | 2000 | 70
April | www.cheesecake.com | 1 | 99 | 2000 | 3333343 | 89 | 2000 | 89
April | www.cheesecake.com | 2 | 97 | 2000 | 6666666 | 59 | 2000 | 90
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
May1 | www.bestfootball.com | 1 | 99 | 1000 | 888888 | 49 | 200 | 50
May1 | www.bestfootball.com | 2 | 98 | 1000 | 999999 | 69 | 2000 | 70
May1 | www.cheesecake.com | 1 | 99 | 2000 | 3333343 | 89 | 2000 | 89
May1 | www.cheesecake.com | 2 | 97 | 2000 | 6666666 | 59 | 2000 | 90
May1 | www.cheesecake.com | 3 | 90 | 2000 | 7777777 | 29 | 200 | 19
May1 | www.cheesecake.com | 3 | 900 | 2000 | 8864353 | 19 | 200 | 19
May1 | www.smartphone.com | 1 | 99 | 3000 | 9090909 | 11 | 20 | 10
May1 | www.smartphone.com | 2 | 66 | 3000 | 9000099 | 11 | 20 | 10
May1 | www.junglejoy.com | 1 | 11 | 4000 | 9090909 | 29 | 200 | 19
may
may
may
may
may
may
may
may
may