Hi - i have a workbook that has headers that contains ALL possible catolog items. Then each student has 1 row and the quantity ordered is placed in the corresponding row under the header.
I need to format this so that each student has one row for each item ordered.
Attached is a sample workbook showing my current format, and my desired format.
Please forgive ignorance as the catolog item names span from column L - BV in the prod workbook not just 10 items like shown in this sample.
Bookmarks