FullName |
ShippingAddress |
ShippingDate |
TrackingNumbers |
ItemNum |
ItemDescription |
Units |
|
Doe, John |
12345 ABC Road Sample City, ST 123456 |
8/1/2012 |
1Z123456789123456 |
123456789 |
This Is An Example Description 1 |
124 |
|
Doe, John |
12345 ABC Road Sample City, ST 123456 |
8/1/2012 |
1Z123456789654231 |
1Z2345678 |
This Is An Example Description 2 |
0 |
|
Doe, John 2 |
654321 ABC Road Sample City, ST 123456 |
8/1/15 |
1Z123456789123456 |
123456789 |
This Is An Example Description 2 |
124 |
|
Doe, John 2 |
654321 ABC Road Sample City, ST 123456 |
8/1/15 |
1Z123456789654231 |
1Z2345678 |
This Is An Example Description 2 |
0 |
|
Doe, John 3 |
145623 ABC Road Sample City, ST 123456 |
8/1/15 |
1Z123456789123456 |
123456789 |
This Is An Example Description |
124 |
|
Doe, John 3 |
145623 ABC Road Sample City, ST 123456 |
8/1/15 |
1Z123456789123456 |
1Z2345678 |
This Is An Example Description |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(As you can see, it is group-by (FullName + ShippingAddress + ShippingDate), I colored it for you for easier seeing)
Attached, please find the output report that come out from this dataset.
Thanks
Lamk.