Spreadsheet: 800615d1665757272-power-query-unpivot-columns-and-then-append-them-example
Sheet: Objective

 | Category | SKU 1 | SKU 1 Quantity | SKU 2 | SKU 2 Quantity | SKU 3 | SKU 3 Quantity | SKU 4 | SKU 4 Quantity | SKU 5 | SKU 5 Quantity |  |  |  |  |  |  | Category | SKU | Quantity
 | Candy | XX202 | 352900 | XX278 | 391200 | XX141 | 51100 | XX903 | 253800 | XX930 | 7600 |  |  |  |  |  |  | Candy | XX202 | 352900
 | Chocolate | XX885 | 303400 | XX93 | 308200 | XX795 | 119300 | XX870 | 132700 | XX694 | 144400 |  |  |  |  |  |  | Chocolate | XX885 | 303400
 | Biscuits | XX589 | 294200 | XX560 | 67100 | XX67 | 440700 | XX440 | 492400 | [NAME] | 61400 |  |  |  |  |  |  | Biscuits | XX589 | 294200
 | Chocolate | XX879 | 68000 | XX698 | 412400 | XX343 | 354500 | XX517 | 446400 | [NAME] | 198600 |  |  |  |  |  |  | Chocolate | XX879 | 68000
 | Chocolate | XX110 | 137600 | XX495 | 338100 | XX71 | 42700 | XX982 | 228300 | XX125 | 326000 |  |  |  |  |  |  | Chocolate | XX110 | 137600
 | Chocolate | [NAME] | 4000 | XX728 | 441500 | [NAME] | 269000 | [NAME] | 204000 | XX998 | 47400 |  |  |  |  |  |  | Chocolate | [NAME] | 4000
 | Biscuits | XX848 | 268400 | XX835 | 155800 | XX41 | 79500 | XX695 | 103500 | XX728 | 492300 |  |  |  |  |  |  | Biscuits | XX848 | 268400
 | Gum | XX1 | 306100 | XX441 | 499200 | [NAME] | 292800 | [NAME] | 132300 | XX28 | 187600 |  |  |  |  |  |  | Gum | XX1 | 306100
 | Gum | XX64 | 411300 | XX934 | 154900 | XX205 | 422600 | XX359 | 482500 | [NAME] | 139100 |  |  |  |  |  |  | Gum | XX64 | 411300
 | Candy | XX58 | 193300 | XX654 | 253000 | XX853 | 362000 | XX439 | 375600 | XX813 | 172500 |  |  |  |  |  |  | Candy | XX58 | 193300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX278 | 391200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX93 | 308200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX560 | 67100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX698 | 412400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX495 | 338100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX728 | 441500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX835 | 155800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | XX441 | 499200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | XX934 | 154900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX654 | 253000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX141 | 51100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX795 | 119300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX67 | 440700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX343 | 354500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX71 | 42700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | [NAME] | 269000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX41 | 79500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | [NAME] | 292800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | XX205 | 422600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX853 | 362000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX903 | 253800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX870 | 132700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX440 | 492400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX517 | 446400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX982 | 228300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | [NAME] | 204000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX695 | 103500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | [NAME] | 132300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | XX359 | 482500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX439 | 375600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX930 | 7600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX694 | 144400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | [NAME] | 61400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | [NAME] | 198600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX125 | 326000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate | XX998 | 47400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biscuits | XX728 | 492300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | XX28 | 187600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gum | [NAME] | 139100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Candy | XX813 | 172500