Spreadsheet: 795686d1662855099-quickbooks-multiple-data-sources-power-query-and-formatting-ideal-results
Sheet: Sheet2

Item | [NAME].Item.1 | [NAME].Description | On Hand | Avg Cost | Asset Value | [NAME].Active Status | [NAME].Type | [NAME].MPN | [NAME].Reorder Pt (Min) | [NAME].Weight (oz) | [NAME].Restricted | [NAME].MSRP | [NAME].Brand | [NAME].Preferred Vendor
[NAME] |  |  | 0 | 0 | 0
TTS-BXFOX102 | [NAME] | Trick or Treat Studios - American Horror Story Cult - Puzzle Face Enamel Pin | 10 | 3.45 | 34.5 | Active | Inventory Part | 8.11501E+11 | 1 | 0.5 | Yes | 11.99 | Trick or Treat Studios
TTS-SFGP101 | [NAME] | Trick or Treat Studios - Tragedy Girls - Makayla Enamel Pin | 10 | 3.45 | 34.5 | Active | Inventory Part | 8.11501E+11 | 1 | 0.5 | Yes | 11.99 | Trick or Treat Studios
TTS-BXFOX103 | [NAME] | Trick or Treat Studios - American Horror Story Cult - Holes Enamel Pin | 10 | 3.45 | 34.5 | Active | Inventory Part | 8.11501E+11 | 1 | 0.5 | Yes | 11.99 | Trick or Treat Studios
TTS-SFCBS105 | [NAME] | Trick or Treat Studios - The Twilight Zone - The Howling Man Enamel Pin | 10 | 3.45 | 34.5 | Active | Inventory Part | 8.11501E+11 | 1 | 0.5 | Yes | 11.99 | Trick or Treat Studios
TTS-BXFOX104 | [NAME] | Trick or Treat Studios - American Horror Story Cult - Flip Flop Enamel Pin | 10 | 3.44 | 34.4 | Active | Inventory Part | 8.11501E+11 | 1 | 0.5 | Yes | 11.99 | Trick or Treat Studios
TTS-SFGP100 | [NAME] | Trick or Treat Studios - Tragedy Girls - Sadie Enamel Pin | 10 | 3.45 | 34.5 | Active | Inventory Part | 8.11501E+11 | 1 | 0.5 | Yes | 11.99 | Trick or Treat Studios
Board Games - Other |  |  | 0 | 0 | 0
USO-MN078307 | Games:Board Games | The OP (USAopoly) - Board Game - Monopoly Southpark | 3 | 23.8 | 71.4 | Active | Inventory Part | 7.00304E+11 | 1 | 38 | Yes | 39.99 | Usaopoly, Inc
USO-CM005637 | Games:Board Games | The OP (USAopoly) Super Mario Checkers & Tic Tac Toe | 2 | 8.93 | 17.86 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Yes | 14.99 | Usaopoly, Inc
USO-MN006025 | Games:Board Games | The OP (USAopoly) - Board Game - Monopoly The Simpsons | 3 | 23.8 | 71.4 | Active | Inventory Part | 7.00304E+11 | 1 | 37 | Yes | 39.99 | Usaopoly, Inc
USO-MN137729 | Games:Board Games | The OP (USAopoly) - Board Game - Monopoly Garbage Pail Kids | 3 | 23.8 | 71.4 | Active | Inventory Part | 7.00304E+11 | 1 | 37 | Yes | 39.99 | Usaopoly, Inc
USO-YZ004261 | Games:Board Games | The OP (USAopoly) - Yahtzee Nightmare Before Xmas | 2 | 11.9 | 23.8 | Active | Inventory Part | 7.00304E+11 | 1 | 12 | Yes | 19.99 | Usaopoly, Inc
MTT-42003 | Games:Board Games | UNO Card Game | 6 | 4.24 | 25.44 | Active | Inventory Part | [PHONE] | 1 | 6.5 | No | 5.99 | Mattel
USO-OP004261 | Games:Board Games | The OP (USAopoly) - Board Game - Operation Nightmare Before Christmas | 2 | 17.85 | 35.7 | Active | Inventory Part | 7.00304E+11 | 1 | 22 | Yes | 29.99 | Usaopoly, Inc
MTT-GWM70 | Games:Board Games | UNO [NAME] | 7 | 4.24 | 29.68 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-FNC42 | Games:Board Games | UNO [NAME] | 2 | 4.24 | 8.48 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-FNC46 | Games:Board Games | UNOcorns | 1 | 4.24 | 4.24 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-DYC15 | Games:Board Games | UNO Emojis | 2 | 4.24 | 8.48 | Active | Inventory Part | 8.87961E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-DRD00 | Games:Board Games | UNO Super Mario Bros | 4 | 4.24 | 16.96 | Active | Inventory Part | 8.87961E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-FNC47 | Games:Board Games | UNO WWE | 0 | 4.24 | 0 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-FPD61 | Games:Board Games | UNO Minecraft | 2 | 4.24 | 8.48 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-GKD75 | Games:Board Games | UNO Minions ROG | 2 | 4.24 | 8.48 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
MTT-GMM14 | Games:Board Games | UNO Braille | 0 | 6.9 | 0 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 9.99 | Mattel
MTT-FNC48 | Games:Board Games | UNO Shark Week | 0 | 4.24 | 0 | Active | Inventory Part | 8.87962E+11 | 1 | 6 | No | 5.99 | Mattel
Puzzle - Other |  |  | 0 | 0 | 0
USO-PZ078-655 | Games:Puzzle | The OP (USAopoly) - Puzzle - South Park Go Cows | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-671 | Games:Puzzle | The OP (USAopoly) - Puzzle - Robot Chicken It Was Only a Dream | 5 | 8.92 | 44.6 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-720 | Games:Puzzle | The OP (USAopoly) - Puzzle - Shining Come Play With Us | 2 | 8.93 | 17.86 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ078-307 | Games:Puzzle | The OP (USAopoly) - Puzzle - South Park Paper Bus Stop | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ085-666 | Games:Puzzle | The OP (USAopoly) - Puzzle - Rick and [NAME] Pooper | 6 | 8.93 | 53.58 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ137-737 | Games:Puzzle | The OP (USAopoly) - Puzzle - Garbage Pail Kids Palooza | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-103 | Games:Puzzle | The OP (USAopoly) - Puzzle - Batman Tango With Evil | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ137-729 | Games:Puzzle | The OP (USAopoly) - Puzzle - Garbage Pail Kids Yuck | 6 | 8.93 | 53.58 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ137-691 | Games:Puzzle | The OP (USAopoly) - Puzzle - Garbage Pail Kids Home Gross Home | 5 | 8.92 | 44.6 | Active | Inventory Part | 7.00304E+11 | 1 | 23 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ137-692 | Games:Puzzle | The OP (USAopoly) - Puzzle - Garbage Pail Kids Thrills and Chills | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ006-025 | Games:Puzzle | The OP (USAopoly) - Puzzle - Simpsons Cast of Thousands | 0 | 8.93 | 0 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ006-633 | Games:Puzzle | The OP (USAopoly) - Puzzle - Bob's Burger Dream | 5 | 8.93 | 44.65 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ005-690 | Games:Puzzle | The OP (USAopoly) - Puzzle - Zelda Hyrule Map | 5 | 8.92 | 44.6 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ005-676 | Games:Puzzle | The OP (USAopoly) - Puzzle - Super Mario Happy Holidays | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ005-678 | Games:Puzzle | The OP (USAopoly) - Puzzle - Mario Kart | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ006-695 | Games:Puzzle | The OP (USAopoly) - Puzzle - Bob's Burgers Wonder Wharf | 3 | 8.92 | 26.76 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-660 | Games:Puzzle | The OP (USAopoly) - Puzzle - Batman I Am The Night | 6 | 8.92 | 53.52 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-662 | Games:Puzzle | The OP (USAopoly) - Puzzle - IT Chapter 2 Return To Derry | 3 | 8.93 | 26.79 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-629 | Games:Puzzle | The OP (USAopoly) - Puzzle - [NAME] | 6 | 8.93 | 53.58 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ006-697 | Games:Puzzle | The OP (USAopoly) - Puzzle - The Simpsons Treehouse of Horror | 5 | 8.92 | 44.6 | Active | Inventory Part | 7.00304E+11 | 1 | 21 | Marketplaces | 14.99 | Usaopoly, Inc
USO-PZ010-544 | Games:Puzzle | The OP (USAopoly) - Puzzle - Scooby-Doo Meddling Kids | 6 | 8.93 | 53.58 | Active | Inventory Part | 7.00304E+11 | 1 | 20 | Marketplaces | 14.99 | Usaopoly, Inc
Games - Other |  |  | 0 | 0 | 0