C
Chip
I have two stores. I have a spreadsheet generated by company software that
shows inventory at both stores, but on separate lines. For example:
Store Item Qty Qty Store 2
1 A 4 ?
2 A 6
I want to move the “6†from the second line to the “?†on the first line. I
can then sort by Store and delete all records from Store 2 and end up with:
Store Item Qty Qty Store 2
1 A 4 6
Can anyone help?
shows inventory at both stores, but on separate lines. For example:
Store Item Qty Qty Store 2
1 A 4 ?
2 A 6
I want to move the “6†from the second line to the “?†on the first line. I
can then sort by Store and delete all records from Store 2 and end up with:
Store Item Qty Qty Store 2
1 A 4 6
Can anyone help?