Tabular format help

I'm new to this forum thing so please bare with me. i'm having issues with organizing my data in a pivot table for Excel 2007. When I create a pivot and some of the rows have the same data, it only puts it once at the top and doesn't fill in the rest of the cells (in tabular form). Not sure if I'm explaining this well.
Cell A2, B2, and C2 have data.
Cell A3 is the same as A2 so it leaves it blank if i have something different in B3 and C3. Make sense?

Does anyone know how to fix it so it will fill in all the fields so each row shows the data (eg. so A3 will fill in)? otherwise I end up doing it manually.
thanks.

pivot tables count how many toms, ***** and harrys, say, in a list of names, if there are no toms the name tom will be absent from the pivot table.

if you want to list out every tom, with, say, their make of car, you have to tackle it another way....

Thanks, but that's not really what i was trying to say.