Here's my situation. I am a contractor that buys widgets here in the states and installs them overseas. I have a spreadsheet that tracks material through multiple stages (Purchasing, receiving, packing, shipping to site). The first six columns deal with purchasing (See below)
.
The issue is the next section of columns. Even though I buy 1000 widgets, they may not all come in a single shipment. So currently I have multiple columns for receiving.
Same thing for the outbound shipments. All the widgets may not fit on a single pallet, or I may not need to send all of them at once.
So this is what my sheet looks like if i receive two shipments of widgets and ship to pallets of widgets.
What I would much rather do, if at all possible, is split the row after column G. So if I receive or ship more than once on a single Purchase of widgets, instead of having multiple columns have multiple rows.
The idea is that I can sort or filter by recvd date, or shipment # in a single column.
Hopefully that makes since.
.
The issue is the next section of columns. Even though I buy 1000 widgets, they may not all come in a single shipment. So currently I have multiple columns for receiving.
Same thing for the outbound shipments. All the widgets may not fit on a single pallet, or I may not need to send all of them at once.
So this is what my sheet looks like if i receive two shipments of widgets and ship to pallets of widgets.
What I would much rather do, if at all possible, is split the row after column G. So if I receive or ship more than once on a single Purchase of widgets, instead of having multiple columns have multiple rows.
The idea is that I can sort or filter by recvd date, or shipment # in a single column.
Hopefully that makes since.
