Hello & Welcome to the Forum,

It's awfully hard to get to the crux of your dilemma, so either post a workbook with a clear understanding of what you are trying to achieve or see if this helps...

http://www.contextures.com/CreatePivotTable.html