Spreadsheet: 860677d1708687085-alternatives-to-power-query-for-appending-multiple-tables-sample-stack
Sheet: stack

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