I am working on a set of data and wants to combine/pair two text fields in a way that they appear as single pair on pivot report in values area.

Need advice that can it be done in Excel 2007 through pivoting or advice any other probable solution