Using Pivot Table to Consolidate multiple rows of data

Nrussell12586 

Just looking at your workbook, my guess is that the problem here has to do with the way your database is arrayed. You've done already some of the work of a Pivot Table--i.e., in columns Y through AL (under the red heading) you've already done some cross-tabulating--and that interferes with things. As Obi-wan says, "Trust the Force, Luke"

Have you done Pivot tables in the past? Here's one of any number of good resources of "Tips" to create well-functioning Pivot Tables. You'll see that having clean and well organized source data is right at the top of the list. https://exceljet.net/pivot-table-tips