I have 3 sheets that contain data as shown below:
Posted sheet:
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
Item Code
Name
Date
Trans. Type
Trans. #
UOM
Pack
Quantity
Total
101
Patty -Whopper
3/30/2018
Out
18873
CAS
144
2
288
103
Patty -Chicken Roya...