Spreadsheet: 860679d1708688074-alternatives-to-power-query-for-appending-multiple-tables-sample-stack-aligw
Sheet: stack

Part Number | QTY | Colour | SUPPLIER |  |  |  |  | SUPPLIER | Part Number | Colour | Sum of QTY
 | 23 | WHITE | DIXONS |  |  |  |  | CURRYS | 18483 | BLACK | 45 |  |  | 18483 | BLACK | 45
15883 | 20 | BLACK | DIXONS |  |  |  |  |  |  | GREEN | 14 |  | CURRYS | 18483 | GREEN | 14
17379 | 19 | GREEN | PC WORLD |  |  |  |  |  | 27379 | BLACK | 56 |  | CURRYS | 27379 | BLACK | 56
18483 | 24 | BLACK | CURRYS |  |  |  |  |  |  | GREEN | 15 |  | CURRYS | 27379 | GREEN | 15
25002 | 8 | BLACK | DIXONS |  |  |  |  |  | 76248 | BLACK | 75 |  | CURRYS | 76248 | BLACK | 75
27379 | 20 | BLACK | CURRYS |  |  |  |  |  | 80668 | BLACK | 43 |  | CURRYS | 80668 | BLACK | 43
31070 | 4 | GREEN | PC WORLD |  |  |  |  |  | 82221 | BLACK | 35 |  | CURRYS | 82221 | BLACK | 35
35400 | 14 | WHITE | DIXONS |  |  |  |  |  |  | WHITE | 8 |  | CURRYS | 82221 | WHITE | 8
38561 | 2 | GREEN | PC WORLD |  |  |  |  |  | 87808 | BLACK | 30 |  | CURRYS | 87808 | BLACK | 30
41563 | 12 | WHITE | PC WORLD |  |  |  |  |  |  | WHITE | 4 |  | CURRYS | 87808 | WHITE | 4
42202 | 20 | WHITE | DIXONS |  |  |  |  | DIXONS | 12292 | GREEN | 12 |  | DIXONS | 12292 | GREEN | 12
43634 | 22 | WHITE | DIXONS |  |  |  |  |  |  | WHITE | 59 |  | DIXONS | 12292 | WHITE | 59
45852 | 0 | WHITE | PC WORLD |  |  |  |  |  | 15883 | BLACK | 46 |  | DIXONS | 15883 | BLACK | 46
53446 | 11 | WHITE | DIXONS |  |  |  |  |  |  | GREEN | 14 |  | DIXONS | 15883 | GREEN | 14
53466 | 15 | BLACK | DIXONS |  |  |  |  |  | 25002 | BLACK | 37 |  | DIXONS | 25002 | BLACK | 37
57245 | 0 | WHITE | DIXONS |  |  |  |  |  |  | GREEN | 6 |  | DIXONS | 25002 | GREEN | 6
61033 | 10 | WHITE | PC WORLD |  |  |  |  |  | 35400 | GREEN | 33 |  | DIXONS | 35400 | GREEN | 33
61208 | 13 | WHITE | DIXONS |  |  |  |  |  |  | WHITE | 23 |  | DIXONS | 35400 | WHITE | 23
66184 | 21 | WHITE | PC WORLD |  |  |  |  |  | 42202 | WHITE | 44 |  | DIXONS | 42202 | WHITE | 44
71187 | 17 | GREEN | PC WORLD |  |  |  |  |  | 43634 | WHITE | 59 |  | DIXONS | 43634 | WHITE | 59
71313 | 19 | GREEN | PC WORLD |  |  |  |  |  | 53446 | WHITE | 62 |  | DIXONS | 53446 | WHITE | 62
76248 | 18 | BLACK | CURRYS |  |  |  |  |  | 53466 | BLACK | 36 |  | DIXONS | 53466 | BLACK | 36
77180 | 2 | WHITE | DIXONS |  |  |  |  |  |  | WHITE | 26 |  | DIXONS | 53466 | WHITE | 26
80255 | 24 | WHITE | DIXONS |  |  |  |  |  | 57245 | GREEN | 10 |  | DIXONS | 57245 | GREEN | 10
80668 | 3 | BLACK | CURRYS |  |  |  |  |  |  | WHITE | 19 |  | DIXONS | 57245 | WHITE | 19
82221 | 12 | BLACK | CURRYS |  |  |  |  |  | 61208 | BLACK | 22 |  | DIXONS | 61208 | BLACK | 22
87739 | 16 | GREEN | PC WORLD |  |  |  |  |  |  | WHITE | 41 |  | DIXONS | 61208 | WHITE | 41
87808 | 14 | BLACK | CURRYS |  |  |  |  |  | 77180 | BLACK | 0 |  | DIXONS | 77180 | BLACK | 0
94836 | 6 | BLACK | DIXONS |  |  |  |  |  |  | GREEN | 5 |  | DIXONS | 77180 | GREEN | 5
12292 | 22 | WHITE | DIXONS |  |  |  |  |  |  | WHITE | 14 |  | DIXONS | 77180 | WHITE | 14
15883 | 7 | BLACK | DIXONS |  |  |  |  |  | 80255 | BLACK | 44 |  | DIXONS | 80255 | BLACK | 44
17379 | 3 | GREEN | PC WORLD |  |  |  |  |  |  | WHITE | 34 |  | DIXONS | 80255 | WHITE | 34
18483 | 18 | BLACK | CURRYS |  |  |  |  |  | 94836 | BLACK | 41 |  | DIXONS | 94836 | BLACK | 41
25002 | 13 | BLACK | DIXONS |  |  |  |  | PC WORLD | 17379 | GREEN | 54 |  | PC WORLD | 17379 | GREEN | 54
27379 | 19 | BLACK | CURRYS |  |  |  |  |  | 31070 | GREEN | 64 |  | PC WORLD | 31070 | GREEN | 64
31070 | 15 | GREEN | PC WORLD |  |  |  |  |  | 38561 | GREEN | 44 |  | PC WORLD | 38561 | GREEN | 44
35400 | 9 | WHITE | DIXONS |  |  |  |  |  | 41563 | GREEN | 26 |  | PC WORLD | 41563 | GREEN | 26
38561 | 23 | GREEN | PC WORLD |  |  |  |  |  |  | WHITE | 30 |  | PC WORLD | 41563 | WHITE | 30
41563 | 18 | WHITE | PC WORLD |  |  |  |  |  | 45852 | WHITE | 60 |  | PC WORLD | 45852 | WHITE | 60
42202 | 14 | WHITE | DIXONS |  |  |  |  |  | 61033 | GREEN | 22 |  | PC WORLD | 61033 | GREEN | 22
43634 | 1 | WHITE | DIXONS |  |  |  |  |  |  | WHITE | 51 |  | PC WORLD | 61033 | WHITE | 51
45852 | 15 | WHITE | PC WORLD |  |  |  |  |  | 66184 | BLACK | 15 |  | PC WORLD | 66184 | BLACK | 15
53446 | 20 | WHITE | DIXONS |  |  |  |  |  |  | GREEN | 21 |  | PC WORLD | 66184 | GREEN | 21
53466 | 21 | BLACK | DIXONS |  |  |  |  |  |  | WHITE | 27 |  | PC WORLD | 66184 | WHITE | 27
57245 | 12 | WHITE | DIXONS |  |  |  |  |  | 71187 | BLACK | 15 |  | PC WORLD | 71187 | BLACK | 15
61033 | 24 | WHITE | PC WORLD |  |  |  |  |  |  | GREEN | 33 |  | PC WORLD | 71187 | GREEN | 33
61208 | 15 | WHITE | DIXONS |  |  |  |  |  | 71313 | BLACK | 1 |  | PC WORLD | 71313 | BLACK | 1
66184 | 6 | WHITE | PC WORLD |  |  |  |  |  |  | GREEN | 46 |  | PC WORLD | 71313 | GREEN | 46
71187 | 5 | GREEN | PC WORLD |  |  |  |  |  | 87739 | BLACK | 18 |  | PC WORLD | 87739 | BLACK | 18
71313 | 13 | GREEN | PC WORLD |  |  |  |  |  |  | GREEN | 19 |  | PC WORLD | 87739 | GREEN | 19
76248 | 25 | BLACK | CURRYS |  |  |  |  |  |  | WHITE | 8 |  | PC WORLD | 87739 | WHITE | 8
77180 | 12 | WHITE | DIXONS |  |  |  |  | (blank) | (blank) | (blank) |  |  | Total |  |  | 1566
80255 | 10 | WHITE | DIXONS
80668 | 7 | BLACK | CURRYS
82221 | 19 | BLACK | CURRYS
87739 | 3 | GREEN | PC WORLD
87808 | 14 | BLACK | CURRYS
94836 | 19 | BLACK | DIXONS
12292 | 12 | GREEN | DIXONS
15883 | 14 | GREEN | DIXONS
17379 | 9 | GREEN | PC WORLD
18483 | 14 | GREEN | CURRYS
25002 | 6 | GREEN | DIXONS
27379 | 15 | GREEN | CURRYS
31070 | 23 | GREEN | PC WORLD
35400 | 23 | GREEN | DIXONS
38561 | 11 | GREEN | PC WORLD
41563 | 22 | GREEN | PC WORLD
42202 | 9 | WHITE | DIXONS
43634 | 11 | WHITE | DIXONS
45852 | 23 | WHITE | PC WORLD
53446 | 17 | WHITE | DIXONS
53466 | 20 | WHITE | DIXONS
57245 | 7 | WHITE | DIXONS
61033 | 17 | WHITE | PC WORLD
61208 | 13 | WHITE | DIXONS
66184 | 15 | BLACK | PC WORLD
71187 | 15 | BLACK | PC WORLD
71313 | 1 | BLACK | PC WORLD
76248 | 15 | BLACK | CURRYS
77180 | 0 | BLACK | DIXONS
80255 | 24 | BLACK | DIXONS
80668 | 14 | BLACK | CURRYS
82221 | 4 | BLACK | CURRYS
87739 | 18 | BLACK | PC WORLD
87808 | 2 | BLACK | CURRYS
94836 | 9 | BLACK | DIXONS
12292 | 14 | WHITE | DIXONS
15883 | 19 | BLACK | DIXONS
17379 | 23 | GREEN | PC WORLD
18483 | 3 | BLACK | CURRYS
25002 | 16 | BLACK | DIXONS
27379 | 17 | BLACK | CURRYS
31070 | 22 | GREEN | PC WORLD
35400 | 10 | GREEN | DIXONS
38561 | 8 | GREEN | PC WORLD
41563 | 4 | GREEN | PC WORLD
42202 | 1 | WHITE | DIXONS
43634 | 25 | WHITE | DIXONS
45852 | 22 | WHITE | PC WORLD
53446 | 14 | WHITE | DIXONS
53466 | 6 | WHITE | DIXONS
57245 | 10 | GREEN | DIXONS
61033 | 22 | GREEN | PC WORLD
61208 | 22 | BLACK | DIXONS
66184 | 21 | GREEN | PC WORLD
71187 | 11 | GREEN | PC WORLD
71313 | 14 | GREEN | PC WORLD
76248 | 17 | BLACK | CURRYS
77180 | 5 | GREEN | DIXONS
80255 | 20 | BLACK | DIXONS
80668 | 19 | BLACK | CURRYS
82221 | 8 | WHITE | CURRYS
87739 | 8 | WHITE | PC WORLD
87808 | 4 | WHITE | CURRYS
94836 | 7 | BLACK | DIXONS