I am trying to figure out a way to take a list of packages my runners can apply for and summarize by runner, the items in that package. You will see on the attached spreadsheet. There are 3 tabs. The first tab is the packages my runners can apply for. Each package (Bronze, Silver, Gold) has multiple lines (Shoe Reward & Shoe Discount). You will see on the second tab (Runners) are a list of a few of my runners and which package they applied for. On the third tab (RESULTS), that is how I am wanting the results to end up looking like. That RESULTS tab shows the runners, package, shoe reward and shoe discount. The RESULTS tab combines the information from the Packages and Runners tabs. Does that make sense? Any ideas how I can do this? Thanks!!