From your example file, it remains unclear, what you really want to do. Attached is a file with an example, how I'd set up the data entry, and how a report sheet may be designed.
But I have there no info, how the data really must be read into report. P.e. there are several rows for same article, with some of them completed, and some pending or back ordered. How to handle such records? E.g. must all records not completed, and having ListDate earlier than the row with completed status, left out? Or some other rule must applied?

Attached Files

WendingList.xlsx (40.0 KB, 5 views)