Order Form Consolidation Help
I'm making order forms for my company that have part numbers in columns and then sizes in rows. So the customer inserts a qty in the box under the size they want for that part number. In order to upload this into our online system, all the quantities and part numbers need to be in a 2-column list (with one column being quanties and one column being part numbers with sizes). Last year I went through and did an "=" for each cell, but that took forever and this year I'm in a time crunch. Does anyone know a quick way for me to convert my data into a list like this? Thanks!
|