Spreadsheet: 851047d1701301510-trouble-with-consolidating-data-sample-file-cabiinets
Sheet: Doors

First Door Length | Second Door Length | Third Door Length | Forth Door Length | Door Width | Door Qty | Label Full | Grain | Label |  | Comb
28 |  |  |  | 13.875 | 1 | FHSDB1, Page 1, Doors | V | FHSDB1, Page 1
28 | 25 | 32 | 28 | 13.875 | 4 | FHSDB2, Page 1, Doors | V | FHSDB2, Page 1
23.5 |  |  |  | 14.875 | 1 | FHSDB3, Page 2.1, Doors | V | FHSDB3, Page 2.1
42 |  |  |  | 19.375 | 2 | DDW9, Page 7.1, Doors | V | DDW9, Page 7.1
42 |  | 24 |  | 19.375 | 2 | DDW10, Page 7.1, Doors | V | DDW10, Page 7.1
42 |  |  |  | 19.375 | 2 | DDW5, Page 7.1, Doors | V | DDW5, Page 7.1
42 |  |  |  | 17.875 | 2 | DDW9, Page 7.12, Doors | V | DDW9, Page 7.12
42 |  | 56 |  | 17.875 | 2 | DDW10, Page 7.12, Doors | V | DDW10, Page 7.12
42 |  |  |  | 23.875 | 1 | SDW1, Page 5, Doors | V | SDW1, Page 5
42 |  |  |  | 11.875 | 2 | DDW1, Page 5, Doors | V | DDW1, Page 5
30 |  |  |  | 14.875 | 2 | DDW2, Page 5, Doors | V | DDW2, Page 5
42 |  |  |  | 11.875 | 2 | DDW3, Page 5, Doors | V | DDW3, Page 5
 | 22.3125 |  |  | 14.875 | 2 | SNK1, Page 5, Doors | V | SNK1, Page 5
42 |  |  |  | 17.875 | 2 | DDW4, Page 6, Doors | V | DDW4, Page 6
42 |  |  |  | 17.875 | 2 | [NAME], Page 6, Doors | V | DDW5, Page 6
42 |  |  |  | 17.875 | 2 | DDW6, Page 6, Doors | V | DDW6, Page 6
42 |  |  |  | 23.875 | 1 | SDW2, Page 6, Doors | V | SDW2, Page 6
38 |  |  |  | 20.875 | 1 | SDW3, Page 4, Doors | V | SDW3, Page 4
 | 23.875 |  |  | 18.375 | 2 | SNK2, Page 4, Doors | V | SNK2, Page 4
42 |  |  |  | 14.875 | 2 | [NAME], Page 6.2, Doors | V | [NAME], Page 6.2
30 |  |  |  | 17.875 | 2 | DDW6, Page 6.2, Doors | V | DDW6, Page 6.2
42 |  |  |  | 17.875 | 2 | [NAME], Page 6.2, Doors | V | [NAME], Page 6.2
42 |  |  |  | 14.875 | 2 | DDW8, Page 6.2, Doors | V | DDW8, Page 6.2
29.5 |  |  |  | 14.875 | 2 | 3DC4, Page 6.2, Doors | V | 3DC4, Page 6.2
 | 23.875 |  |  | 17.875 | 2 | SNK3, Page 6.2, Doors | V | SNK3, Page 6.2
Format Needed:
Length | [NAME] | Qty | Label | Grain
28 | 13.875 | 1 | FHSDB1, Page 1, Doors | V
28 | 13.875 | 1 | FHSDB2, Page 1, Doors | V
25 | 13.875 | 1 | FHSDB2, Page 1, Doors | V
32 | 13.875 | 1 | FHSDB2, Page 1, Doors | V
28 | 13.875 | 1 | FHSDB2, Page 1, Doors | V
23.5 | 14.875 | 1 | FHSDB3, Page 2.1, Doors | V
42 | 19.375 | 1 | DDW9, Page 7.1, Doors | V
42 | 19.375 | 1 | DDW10, Page 7.1, Doors | V
24 | 19.375 | 1 | DDW10, Page 7.1, Doors | V
42 | 19.375 | 1 | DDW5, Page 7.1, Doors | V
42 | 17.875 | 1 | DDW9, Page 7.12, Doors | V
42 | 17.875 | 1 | DDW10, Page 7.12, Doors | V
56 | 17.875 | 1 | DDW10, Page 7.12, Doors | V
42 | 23.875 | 1 | SDW1, Page 5, Doors | V
42 | 11.875 | 1 | DDW1, Page 5, Doors | V
30 | 14.875 | 1 | DDW2, Page 5, Doors | V
42 | 11.875 | 1 | DDW3, Page 5, Doors | V
22.3125 | 14.875 | 1 | SNK1, Page 5, Doors | V
42 | 17.875 | 2 | DDW4, Page 6, Doors | V
42 | 17.875 | 2 | [NAME], Page 6, Doors | V
42 | 17.875 | 2 | DDW6, Page 6, Doors | V
42 | 23.875 | 1 | SDW2, Page 6, Doors | V
38 | 20.875 | 1 | SDW3, Page 4, Doors | V
18.375 | 23.875 | 2 | SNK2, Page 4, Doors | V
42 | 14.875 | 2 | [NAME], Page 6.2, Doors | V
30 | 17.875 | 2 | DDW6, Page 6.2, Doors | V
42 | 17.875 | 2 | [NAME], Page 6.2, Doors | V
42 | 14.875 | 2 | DDW8, Page 6.2, Doors | V
29.5 | 14.875 | 2 | 3DC4, Page 6.2, Doors | V
23.875 | 17.875 | 2 | SNK3, Page 6.2, Doors | V