Spreadsheet: 180847d1347816008-representing-one-to-many-relationships-in-excel-example-ms-excel-output
Sheet: Sheet1

Order ID | Employee | Order Date | [NAME] | Ship Name | Ship Address | Ship City | Ship State | Ship ZIP/Postal Code
30 | [NAME] | 2006-01-15 00:00:00 | 2006-01-22 00:00:00 | [NAME] | 789 27th Street | Las Vegas | NV | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 27 | 30 | Northwind Traders Beer | 100 | 14 | 0 | 96 | 83
 | 28 | 30 | Northwind Traders Dried Plums | 30 | 3.5 | 0 |  | 63
31 | Jan Kotas | 2006-01-20 00:00:00 | 2006-01-22 00:00:00 | [NAME] | 123 4th Street | New York | NY | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 29 | 31 | Northwind Traders Dried Pears | 10 | 30 | 0 |  | 64
 | 30 | 31 | Northwind Traders Dried Apples | 10 | 53 | 0 |  | 65
 | 31 | 31 | Northwind Traders Dried Plums | 10 | 3.5 | 0 |  | 66
32 | [NAME] | 2006-01-22 00:00:00 | 2006-01-22 00:00:00 | [NAME] | 123 12th Street | Las Vegas | NV | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 32 | 32 | Northwind Traders Chai | 15 | 18 | 0 |  | 67
 | 33 | 32 | Northwind Traders Coffee | 20 | 46 | 0 |  | 68
33 | [NAME] | 2006-01-30 00:00:00 | 2006-01-31 00:00:00 | [NAME] | 123 8th Street | Portland | OR | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 34 | 33 | Northwind Traders Chocolate Biscuits Mix | 30 | 9.2 | 0 | 97 | 81
34 | [NAME] | 2006-02-06 00:00:00 | 2006-02-07 00:00:00 | [NAME] | 123 4th Street | New York | NY | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 35 | 34 | Northwind Traders Chocolate Biscuits Mix | 20 | 9.2 | 0 |  | 69
35 | Jan Kotas | 2006-02-10 00:00:00 | 2006-02-12 00:00:00 | Soo [NAME] | 789 29th Street | Denver | CO | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 36 | 35 | Northwind Traders Chocolate | 10 | 11112.75 | 0 |  | 70
36 | [NAME] | 2006-02-23 00:00:00 | 2006-02-25 00:00:00 | [NAME] | 123 3rd Street | [NAME] | CA | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 37 | 36 | Northwind Traders Clam Chowder | 200 | 9.65 | 0 | 98 | 79
37 | [NAME] | 2006-03-06 00:00:00 | 2006-03-09 00:00:00 | [NAME] | 123 6th Street | Milwaukee | WI | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 38 | 37 | Northwind Traders [NAME] | 17 | 40 | 0 |  | 71
38 | [NAME] | 2006-03-10 00:00:00 | 2006-03-11 00:00:00 | [NAME] | 789 28th Street | Memphis | TN | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 39 | 38 | Northwind Traders Coffee | 300 | 46 | 0 | 99 | 77
39 | Jan Kotas | 2006-03-22 00:00:00 | 2006-03-24 00:00:00 | [NAME] | 123 8th Street | Portland | OR | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 40 | 39 | Northwind Traders Chocolate | 100 | 12.75 | 0 | 100 | 75
40 | [NAME] | 2006-03-24 00:00:00 | 2006-03-24 00:00:00 | [NAME] | 123 10th Street | Chicago | IL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 41 | 40 | Northwind Traders Green Tea | 200 | 2.99 | 0 | 101 | 73
41 | [NAME] | 2006-03-24 00:00:00 |  | Ming-Yang Xie | 123 7th Street | Boise | ID | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 42 | 41 | Northwind Traders Coffee | 300 | 46 | 0 | 102 | 104
42 | [NAME] | 2006-03-24 00:00:00 | 2006-04-07 00:00:00 | [NAME] | 123 10th Street | Chicago | IL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 43 | 42 | Northwind Traders [NAME] | 10 | 25 | 0 |  | 84
 | 44 | 42 | Northwind Traders Cajun Seasoning | 10 | 22 | 0 |  | 85
 | 45 | 42 | Northwind Traders Chocolate Biscuits Mix | 10 | 9.2 | 0 | 103 | 110
43 | [NAME] | 2006-03-24 00:00:00 |  | [NAME] | 123 11th Street | Miami | FL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 46 | 43 | Northwind Traders Dried Plums | 20 | 3.5 | 0 |  | 86
 | 47 | 43 | Northwind Traders Green Tea | 50 | 2.99 | 0 |  | 87
44 | [NAME] | 2006-03-24 00:00:00 |  | [NAME] | 123 1st Street | Seattle | WA | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 48 | 44 | Northwind Traders Chai | 25 | 18 | 0 |  | 88
 | 49 | 44 | Northwind Traders Coffee | 25 | 46 | 0 |  | 89
 | 50 | 44 | Northwind Traders Green Tea | 25 | 2.99 | 0 |  | 90
45 | [NAME] | 2006-04-07 00:00:00 | 2006-04-07 00:00:00 | [NAME] | 789 28th Street | Memphis | TN | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 51 | 45 | Northwind Traders Clam Chowder | 50 | 9.65 | 0 | 104 | 116
 | 52 | 45 | Northwind Traders Crab Meat | 50 | 18.4 | 0 |  | 91
46 | [NAME] | 2006-04-05 00:00:00 | 2006-04-05 00:00:00 | [NAME] | 123 9th Street | Salt Lake City | UT | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 53 | 46 | Northwind Traders Ravioli | 100 | 19.5 | 0 | 105 | 101
 | 54 | 46 | Northwind Traders Mozzarella | 50 | 34.8 | 0 | 106 | 114
47 | [NAME] | 2006-04-08 00:00:00 | 2006-04-08 00:00:00 | [NAME] | 123 6th Street | Milwaukee | WI | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 55 | 47 | Northwind Traders Beer | 300 | 14 | 0 | 107 | 108
48 | [NAME] | 2006-04-05 00:00:00 | 2006-04-05 00:00:00 | [NAME] | 123 8th Street | Portland | OR | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 56 | 48 | Northwind Traders [NAME] | 25 | 40 | 0 | 108 | 106
 | 57 | 48 | Northwind Traders Chocolate Biscuits Mix | 25 | 9.2 | 0 | 109 | 112
50 | [NAME] | 2006-04-05 00:00:00 | 2006-04-05 00:00:00 | [NAME] | 789 25th Street | Chicago | IL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 59 | 50 | Northwind Traders Scones | 20 | 10 | 0 |  | 92
51 | [NAME] | 2006-04-05 00:00:00 | 2006-04-05 00:00:00 | [NAME] | 789 26th Street | Miami | FL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 60 | 51 | Northwind Traders Olive Oil | 25 | 21.35 | 0 |  | 93
 | 61 | 51 | Northwind Traders Clam Chowder | 30 | 9.65 | 0 |  | 94
 | 62 | 51 | Northwind Traders Crab Meat | 30 | 18.4 | 0 |  | 95
55 | [NAME] | 2006-04-05 00:00:00 | 2006-04-05 00:00:00 | Soo [NAME] | 789 29th Street | Denver | CO | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 67 | 55 | Northwind Traders Beer | 87 | 14 | 0 |  | 117
56 | [NAME] | 2006-04-03 00:00:00 | 2006-04-03 00:00:00 | [NAME] | 123 6th Street | Milwaukee | WI | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 66 | 56 | Northwind Traders Chocolate | 10 | 12.75 | 0 | 111 | 99
57 | [NAME] | 2006-04-22 00:00:00 | 2006-04-22 00:00:00 | [NAME] | 789 27th Street | Las Vegas | NV | 99999
58 | Jan Kotas | 2006-04-22 00:00:00 | 2006-04-22 00:00:00 | [NAME] | 123 4th Street | New York | NY | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 84 | 58 | Northwind Traders Marmalade | 40 | 81 | 0 |  | 134
 | 85 | 58 | Northwind Traders Long Grain Rice | 40 | 7 | 0 |  | 135
59 | [NAME] | 2006-04-22 00:00:00 | 2006-04-22 00:00:00 | [NAME] | 123 12th Street | Las Vegas | NV | 99999
60 | [NAME] | 2006-04-30 00:00:00 | 2006-04-30 00:00:00 | [NAME] | 123 8th Street | Portland | OR | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 81 | 60 | Northwind Traders Mozzarella | 40 | 34.8 | 0 |  | 131
61 | [NAME] | 2006-04-07 00:00:00 | 2006-04-07 00:00:00 | [NAME] | 123 4th Street | New York | NY | 99999
62 | Jan Kotas | 2006-04-12 00:00:00 | 2006-04-12 00:00:00 | Soo [NAME] | 789 29th Street | Denver | CO | 99999
63 | [NAME] | 2006-04-25 00:00:00 | 2006-04-25 00:00:00 | [NAME] | 123 3rd Street | [NAME] | CA | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 82 | 63 | Northwind Traders Syrup | 50 | 10 | 0 |  | 132
 | 83 | 63 | Northwind Traders [NAME] | 3 | 40 | 0 |  | 133
64 | [NAME] | 2006-05-09 00:00:00 | 2006-05-09 00:00:00 | [NAME] | 123 6th Street | Milwaukee | WI | 99999
65 | [NAME] | 2006-05-11 00:00:00 | 2006-05-11 00:00:00 | [NAME] | 789 28th Street | Memphis | TN | 99999
66 | Jan Kotas | 2006-05-24 00:00:00 | 2006-05-24 00:00:00 | [NAME] | 123 8th Street | Portland | OR | 99999
67 | [NAME] | 2006-05-24 00:00:00 | 2006-05-24 00:00:00 | [NAME] | 123 10th Street | Chicago | IL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 80 | 67 | Northwind Traders Almonds | 20 | 10 | 0 |  | 130
68 | [NAME] | 2006-05-24 00:00:00 |  | Ming-Yang Xie | 123 7th Street | Boise | ID | 99999
69 | [NAME] | 2006-05-24 00:00:00 |  | [NAME] | 123 10th Street | Chicago | IL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 79 | 69 | Northwind Traders Dried Plums | 15 | 3.5 | 0 |  | 129
70 | [NAME] | 2006-05-24 00:00:00 |  | [NAME] | 123 11th Street | Miami | FL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 78 | 70 | Northwind Traders [NAME] | 20 | 40 | 0 |  | 128
71 | [NAME] | 2006-05-24 00:00:00 |  | [NAME] | 123 1st Street | Seattle | WA | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 77 | 71 | Northwind Traders Crab Meat | 40 | 18.4 | 0 |  | 127
72 | [NAME] | 2006-06-07 00:00:00 | 2006-06-07 00:00:00 | [NAME] | 789 28th Street | Memphis | TN | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 76 | 72 | Northwind Traders Coffee | 5 | 46 | 0 |  | 126
73 | [NAME] | 2006-06-05 00:00:00 | 2006-06-05 00:00:00 | [NAME] | 123 9th Street | Salt Lake City | UT | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 75 | 73 | Northwind Traders Clam Chowder | 10 | 9.65 | 0 |  | 125
74 | [NAME] | 2006-06-08 00:00:00 | 2006-06-08 00:00:00 | [NAME] | 123 6th Street | Milwaukee | WI | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 74 | 74 | Northwind Traders Chocolate | 40 | 12.75 | 0 |  | 124
75 | [NAME] | 2006-06-05 00:00:00 | 2006-06-05 00:00:00 | [NAME] | 123 8th Street | Portland | OR | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 73 | 75 | Northwind Traders Chocolate | 40 | 12.75 | 0 |  | 123
76 | [NAME] | 2006-06-05 00:00:00 | 2006-06-05 00:00:00 | [NAME] | 789 25th Street | Chicago | IL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 72 | 76 | Northwind Traders Cajun Seasoning | 30 | 22 | 0 |  | 122
77 | [NAME] | 2006-06-05 00:00:00 | 2006-06-05 00:00:00 | [NAME] | 789 26th Street | Miami | FL | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 71 | 77 | Northwind Traders [NAME] | 90 | 25 | 0 |  | 121
78 | [NAME] | 2006-06-05 00:00:00 | 2006-06-05 00:00:00 | Soo [NAME] | 789 29th Street | Denver | CO | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 70 | 78 | Northwind Traders Fruit Cocktail | 40 | 39 | 0 |  | 120
79 | [NAME] | 2006-06-23 00:00:00 | 2006-06-23 00:00:00 | [NAME] | 123 6th Street | Milwaukee | WI | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 68 | 79 | Northwind Traders Dried Pears | 30 | 30 | 0 |  | 119
 | 69 | 79 | Northwind Traders Dried Apples | 30 | 53 | 0 |  | 118
80 | [NAME] | 2006-04-25 17:03:55 |  | [NAME] | 123 4th Street | New York | NY | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 86 | 80 | Northwind Traders Gnocchi | 10 | 38 | 0 |  | 136
81 | [NAME] | 2006-04-25 17:26:53 |  | [NAME] | 123 3rd Street | [NAME] | CA | 99999
 | ID | Order ID | Product | Quantity | Unit Price | Discount | [NAME] | Inventory ID
 | 90 | 81 | Northwind Traders Green Tea | 0 | 2.99 | 0
 | 91 | 81 | Northwind Traders Gnocchi | 0 | 38 | 0