Might not be the answer you would have preferred so I'll second the motion just as a means of support to both of you. This
What I don't know is how to create a table that will automatically put the members in the row from the memberlist table, and the products from the products table as the columns.
is the reason why. That is your Excel brain getting in the way of database design, which will only raise barriers along the way. Make sure anything you review covers normalization as a design concept, and make sure you understand the concepts. Once you think you have it figured out, you can always post back here to get your schema validated.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.