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.
Bookmarks